json select question

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

Responses

Browse pgsql-general by date

  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