postgresql migrating JSON to JSONB [duplicate]

March 31, 2023 by Tarik

ALTER TABLE table_with_json
  ALTER COLUMN my_json
  SET DATA TYPE jsonb
  USING my_json::jsonb;