json select question

Поиск
Список
Период
Сортировка
От CS DBA
Тема json select question
Дата
Msg-id 3248b3c2-24c5-c31d-c4c6-58d4f46bc488@consistentstate.com
обсуждение исходный текст
Ответы Re: json select question  (John R Pierce <pierce@hogranch.com>)
Re: json select question  ("FarjadFarid\(ChkNet\)" <farjad.farid@checknetworks.com>)
Список 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

В списке pgsql-general по дате отправления:

Предыдущее
От: Patrick B
Дата:
Сообщение: Re: overwrite column data select - Postgres 9.2
Следующее
От: Patrick B
Дата:
Сообщение: Re: overwrite column data select - Postgres 9.2