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,
try json_object_keys() ...
but this will only pull the top level keys, like (from the first row of
your example) , book_name, author... it won't pull out any second level
fields like first_name, last_name.
you'll likely need to run this on all rows, and do a group by to get
what you need.
thats a pretty messy way of storing data, btw, and not very relational,
having a key name indicate a record type, and tossing all the record
types into the same table.
john r pierce, recycling bits in santa cruz