Search Postgresql Archives

Re: SQL Query Syntax help

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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







[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux