Re: [GENERAL] Accessing structured datatypes using libpq

2014-06-11 Thread Merlin Moncure
On Wed, Jun 11, 2014 at 1:20 AM, Raimo Jormakka wrote: > Hi, > > 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

Re: [GENERAL] Accessing structured datatypes using libpq

2014-06-11 Thread Michael Paquier
On Wed, Jun 11, 2014 at 6:59 PM, Raimo Jormakka wrote: > 2014-06-11 9:44 GMT+03:00 John R Pierce : > >> 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 JS

Re: [GENERAL] Accessing structured datatypes using libpq

2014-06-11 Thread Raimo Jormakka
2014-06-11 9:44 GMT+03:00 John R Pierce : > 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 poss

Re: [GENERAL] Accessing structured datatypes using libpq

2014-06-10 Thread John R Pierce
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

[GENERAL] Accessing structured datatypes using libpq

2014-06-10 Thread Raimo Jormakka
Hi, 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 on