Hi Jan,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 matchedLINE 10: ..._ID","Critical_Decision" as col_Name, "Critical_... ^SQL state: 42804Character: 585After 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 BFrom: Jan Kohnert <nospam001-lists(at)jan-kohnert(dot)de>Sent: Wed, 22 Jan 2020 17:11:56To: pgsql-general(at)lists(dot)postgresql(dot)orgSubject: Re: SQL Query Syntax helpHi,Am Mittwoch, 22. Januar 2020, 12:00:45 CET schrieb srikkanth:[sniped HTML]something likeselect id, 'Col A' as "Col Name", "Col A" as "Col Value"from inputunion allselect id, 'Col B' as "Col Name", "Col B" as "Col Value"from input...order by 1, 2;should work.--Kind regards Jan