From: | CS DBA <cs_dba(at)consistentstate(dot)com> |
---|---|
To: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | json select question |
Date: | 2016-09-21 23:54:01 |
Message-ID: | 3248b3c2-24c5-c31d-c4c6-58d4f46bc488@consistentstate.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
All;
I'm working with a client running postgres 9.2, they have a table with a
"json_data_string" column of type json
the data looks something like this with lots of rows for each (i.e. lots
of json_data_string->book_name rows, lots of
json_data_string->catalog_name rows, etc:
|'{ "book_name": "Book the Fourth", "author": { "first_name": "Charles",
"last_name": "Davis" } }' ||'{ "catalog_name": "Catalog the Fourth", "author": { "first_name":
"Charles", "last_name": "Davis" } }'|
|'{ "magazine_name": "mag4", "author": { "first_name": "Charles",
"last_name": "Davis" } }' |||'{ "category_name": "region", "author": { "first_name": "Charles",
"last_name": "Davis" } }'||
How can i pull a unique list of all json column names? such as book_name, catalog_name, etc
Thanks in advance
From | Date | Subject | |
---|---|---|---|
Next Message | Patrick B | 2016-09-21 23:57:10 | Re: overwrite column data select - Postgres 9.2 |
Previous Message | Patrick B | 2016-09-21 23:11:27 | Re: overwrite column data select - Postgres 9.2 |