Postgres Pro
Downloads
Home   >   mailing lists

Re: From hstore to jsonb (type of column) - Mailing list pgsql-novice

From Alexandre Delanoë
Subject Re: From hstore to jsonb (type of column)
Date
Msg-id 20150401154909.GA15391@delanoe.org
Whole thread Raw
In response to Re: From hstore to jsonb (type of column)  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-novice
Tree view 
Le mardi 31 mars 2015, vers 10:02, Tom Lane écrivait:
> Alexandre Delanoe <debian@delanoe.org> writes:
> > But what would it become for jsonb ?
>
> Just do "USING hstore_to_json(mycolumn)::jsonb".  Eventually there
> will probably be direct jsonb equivalents of all the existing
> json transform functions, but they're not all there yet.

Exactly what I was looking for.
Besides it works like a charm.
Many thanks for your quick help.

Regards,

--
    Alexandre Delanoë

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: From hstore to jsonb (type of column)
Next
From: Hector Vass
Date:
Subject: Re: [SQL] Link Office Word form document with data from PostgreSQL