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?