Manipulate and parse jasonb object in timescaledb(postgresql)

[Steven Schveighoffer]

On 7/14/21 9:00 AM, Alain De Vos wrote:
> When I read a record out of the database I receive a jsonb datatatype as 
> a string.
> How do I convert this string into a json object and parse and manipulate 
> it?

Isn't jsonb just a storage assumption for the database (so it can do 
efficient indexing/searches)? When you get the data back, I would think 
it's just json data you can parse.

I don't have experience with it, but I can't imagine a portable psql 
library that actually implements whatever binary storage format is being 
used inside the DB.

-Steve