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

Alexandre =?iso-8859-1?Q?Delano=EB?= <debian@delanoe.org> writes:
> from hstore to json, I use this:

> ALTER TABLE ONLY mytable
> ALTER COLUMN mycolumn
> TYPE JSON
> USING hstore_to_json(mycolumn)
> ;

> ALTER TABLE ONLY mytable
> ALTER COLUMN mycolumn
> SET DEFAULT '{}'::json
> ;

> 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.

            regards, tom lane