SELECT table_name, column_name FROM information_schema.columns WHERE table_name = 'your_name'; ----- Original Message -----From: hamann w <[email protected]>To: [email protected]: 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 ([email protected])To make changes to your subscription:http://www.postgresql.org/mailpref/pgsql-general
