Re: column names query

[stimits@xxxxxxxxxxx]

SELECT table_name, column_name

FROM information_schema.columns

WHERE table_name = 'your_name';

 

----- Original Message -----
From: hamann w <hamann.w@xxxxxxxxxxx>
To: pgsql-general@xxxxxxxxxxxxxx
Sent: Thu, 07 Sep 2017 07:18:12 -0000 (UTC)
Subject: column names query

Hi,

is there a simple way to retrieve column names from a query - basically the way psql adds
column headings when I do a select?

Best regards
Wolfgang Hamann

--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general