| From: | Robert Haas <robertmhaas(at)gmail(dot)com> |
|---|---|
| To: | "hari(dot)prasath" <hari(dot)prasath(at)zohocorp(dot)com> |
| Cc: | pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Extract Jsonb key and values |
| Date: | 2016-07-01 13:57:17 |
| Message-ID: | CA+TgmoZshFgQ=mQMmacjDpe03vjBHq4VH+JP5MBmbSc9fFwt2g@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Thu, Jun 23, 2016 at 8:52 AM, hari.prasath <hari(dot)prasath(at)zohocorp(dot)com> wrote:
> 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
I'm pretty sure there's some built-in function which can do this, but
this question is off-topic for this mailing list, which is about
feature development for PostgreSQL. You probably want to ask
questions like this on pgsql-general.
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robert Haas | 2016-07-01 13:58:14 | Re: how is the WAL receiver process stopped and restarted when the network connection is broken and then restored? |
| Previous Message | Robert Haas | 2016-07-01 13:56:15 | Re: Comment and function argument names are mismatched in bugmgr.c. |