I want to migrate data from one column (varchar) to another (jsonb)
Column | Type | Modifiers < br />————+—————————–+—- ——————————————
Tag: JSONB
PostgreSQL extracts the keys from JSONB, “Unable to call JSONB_Object_Keys on scalar”
I want to use jsonb to solve the problem in Postgres. There are many problems here, what I want to do is:
SELECT table.column->>’key_1′ as a FROM “table” I tried -> there are some combination