| From: | dfgpostgres <dfgpostgres3(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | PG Unpivot ? |
| Date: | 2025-11-03 17:18:55 |
| Message-ID: | CAAcmDX_KU4A1DWzKmO4XacVQ72+0KZ9rZSvQwHkCWgpqB-Lb2w@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
psql (13.2, server 15.3) on linux
I think they call this "unpivot" in MSSQL ?
How can I get an sql query to return one line per column with... an ID,
column name and value. the ctid for the id field is fine.
Example:
dvdb=# create table unpivot (intcol integer, floatcol float, strcol
varchar);
CREATE TABLE
dvdb=# insert into unpivot (intcol,floatcol,strcol) values
(1,1.1,'one'),(2,2.2,'two'),(3,3.3,'three');
INSERT 0 3
dvdb=# select * from unpivot;
intcol | floatcol | strcol
--------+----------+--------
1 | 1.1 | one
2 | 2.2 | two
3 | 3.3 | three
(3 rows)
I want 9 records returned, each row with 3 cols, 1st col is the ctid,
second is the column name, third is the val.
Thanks in Advance !
| From | Date | Subject | |
|---|---|---|---|
| Next Message | hubert depesz lubaczewski | 2025-11-03 17:22:11 | Re: PG Unpivot ? |
| Previous Message | Bruce Momjian | 2025-11-03 16:59:47 | Re: Enquiry about TDE with PgSQL |