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