psql show column names code example

Example: postgres get columns names

SELECT *
  FROM information_schema.columns
 WHERE table_name   = 'your_table'
     ;