Thanks for your input, it is working exactly what i want, but still i m facing issue because in my table there are different data types they are 10 to 15 columns are Boolean, one primary key, 140 columns are character.
when i m applying the logic on this scenario i m getting the below error.
ERROR: UNION types boolean and character cannot be matched LINE 10: ..._ID","Critical_Decision" as col_Name, "Critical_... ^ SQL state: 42804 Character: 585
After applying the logic i need to take this data into the table.
can you please help me how to write the syntax in this case.
Thanks, Srikanth B
From: Jan Kohnert <nospam001-lists@jan-kohnert.de> Sent: Wed, 22 Jan 2020 17:11:56 To: pgsql-general@lists.postgresql.org Subject: Re: SQL Query Syntax help
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;