Re: SQL Query Syntax help - Mailing list pgsql-general

Hi,

Am Mittwoch, 22. Januar 2020, 12:00:45 CET schrieb srikkanth:
[sniped HTML]

something like

select 
    id, 'Col A' as "Col Name", "Col A" as "Col Value"
from input
union all
select 
    id, 'Col B' as "Col Name", "Col B" as "Col Value"
from input
...
order by
    1, 2;

should work.

-- 
Kind regards Jan