From: | hamann(dot)w(at)t-online(dot)de |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: column names query |
Date: | 2017-09-07 13:26:54 |
Message-ID: | wolfgang-1170907152654.A0430521@noten19.local |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
>> 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
>>
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
From | Date | Subject | |
---|---|---|---|
Next Message | Manuel Gómez | 2017-09-07 13:29:37 | Re: column names query |
Previous Message | hamann.w | 2017-09-07 13:17:49 | Re: column names query |