Extract Jsonb key and values

From: "hari(dot)prasath" <hari(dot)prasath(at)zohocorp(dot)com>
To: "pgsql-hackers" <pgsql-hackers(at)postgresql(dot)org>
Subject: Extract Jsonb key and values
Date: 2016-06-23 12:52:33
Message-ID: 1557d51af03.101052b0329906.6484036696364919796@zohocorp.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi all,

I am having jsonb as C character string received by WAL decoding and want to extract all its key and value pairs.


Which is the best approach for extracting keys and its values?

i) Converting the C string to a PostgreSQL jsonb object
ii) Using open-source json-c library

cheers

- Harry

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2016-06-23 13:26:45 Re: Question and suggestion about application binary compatibility policy
Previous Message Craig Ringer 2016-06-23 12:31:57 Re: Feature suggestions: "dead letter"-savepoint.