Re: From hstore to jsonb (type of column)

From: Alexandre Delanoë <debian(at)delanoe(dot)org>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: From hstore to jsonb (type of column)
Date: 2015-04-01 15:49:09
Message-ID: 20150401154909.GA15391@delanoe.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Le mardi 31 mars 2015, vers 10:02, Tom Lane écrivait:
> Alexandre Delanoe <debian(at)delanoe(dot)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ë

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message scharinger@ws-zwo.de 2015-04-08 09:32:11 pgadmin add schema/database name automaticaly
Previous Message Tom Lane 2015-03-31 14:02:39 Re: From hstore to jsonb (type of column)