>> 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@postgresql.orgSent: 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 addscolumn headings when I do a select? >> >> Best regardsWolfgang Hamann >> >> >> >> -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)To make changes to your subscription:http://www.postgresql.org/mailpref/pgsql-general >> Hi, I am already using something like this (but using pg_attribute table) to retrieve current table layout for static tables. At the moment I am looking for a solution for ad hoc queries Example query select a.col1, case when a.col2 > 0 then a.col3 else b.xcol1 end as mycol3 from a left join b on .... Expected response col1 mycol3 Obviously, I could save the result into a temp table and retrieve the table's heading. 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
