This is probably the start of your quest into this project. No doubt you’ll
need to handle other queries.
So my suggestion is first to rationalise the data storage before digging any
deeper.
From: pgsql-general-ow...@postgresql.org
[mailto:pgsql-general-ow...@postgresql.org]
On 9/21/2016 4:54 PM, CS DBA wrote:
How can i pull a unique list of all json column names? such as book_name,
catalog_name, etc
try json_object_keys() ...
https://www.postgresql.org/docs/current/static/functions-json.html
but this will only pull the top level keys, like (from the first row