Re: column names query

SELECT table_name, column_name
FROM information_schema.columns
WHERE table_name = 'your_name';

----- Original Message -----From: hamann w <hamann(dot)w(at)t-online(dot)de>To: pgsql-general(at)postgresql(dot)orgSent: Thu, 07 Sep 2017 07:18:12 -0000 (UTC)Subject: [GENERAL] column names query

Hi,

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

Best regardsWolfgang Hamann

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