[GENERAL] Accessing structured datatypes using libpq

2014-06-11 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

Re: [GENERAL] Accessing structured datatypes using libpq

2014-06-11 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

Re: [GENERAL] Accessing structured datatypes using libpq

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

Re: [GENERAL] Accessing structured datatypes using libpq

2014-06-11 Thread Michael Paquier
On Wed, Jun 11, 2014 at 6:59 PM, Raimo Jormakka raimo.jorma...@gmail.com wrote: 2014-06-11 9:44 GMT+03:00 John R Pierce pie...@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?

Re: [GENERAL] Accessing structured datatypes using libpq

2014-06-11 Thread Merlin Moncure
On Wed, Jun 11, 2014 at 1:20 AM, Raimo Jormakka raimo.jorma...@gmail.com 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