On Wed, Jun 11, 2014 at 6:59 PM, Raimo Jormakka <raimo.jormakka@xxxxxxxxx> wrote: > 2014-06-11 9:44 GMT+03:00 John R Pierce <pierce@xxxxxxxxxxxx>: > >> 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? Internally yes, representation of those data types on disk is different. However the output result, the one obtained by libpq or any client is similar in appearance. -- Michael
