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? 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
-- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
