Re: Accessing structured datatypes using libpq - Mailing list pgsql-general

From Raimo Jormakka
Subject Re: Accessing structured datatypes using libpq
Date
Msg-id CAMZtG2tJ-bNB3EOEi8rbmzgBzys9GaA1-UbAyweYbH5mbEZBaA@mail.gmail.com
Whole thread Raw
In response to Re: Accessing structured datatypes using libpq  (John R Pierce <pierce@hogranch.com>)
Responses Re: Accessing structured datatypes using libpq
List pgsql-general
2014-06-11 9:44 GMT+03:00 John R Pierce <pierce@hogranch.com>:
On 6/10/2014 11:20 PM, Raimo Jormakka wrote:

What is the recommended way of accessing structured data-types (especially JSONB and HSTORE) using libpq? It seems that by default JSONB data for example is returned as text.

Is it not possible to have binary access to these data-types? If it is possible, then how do I do it exactly as the only thing I get from libpq is a void-pointer?

those are text data types.   there is no binary representations.

Can someone elaborate this a bit? Isn't the key distinction between the JSONB and JSON data-types the fact that the former is a binary format while the latter one is text-based? 

pgsql-general by date:

Previous
From: John R Pierce
Date:
Subject: Re: Accessing structured datatypes using libpq
Next
From: Ravi Kiran
Date:
Subject: eclipse-postgres