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?
