srikkanth wrote: > Can you please help me in writing the syntax for the below mentioned
This looks like an UNPIVOT operation. Here's a generic method that does this without having to specify the columns individually, with the help of json functions: SELECT ID, key, value FROM (SELECT ID, row_to_json(t.*) AS line FROM PivotTableName t) AS r JOIN LATERAL json_each_text(r.line) on (key <> 'ID'); Best regards, -- Daniel Vérité PostgreSQL-powered mailer: http://www.manitou-mail.org Twitter: @DanielVerite
