PostgreSQL documentation recommends usage of jsonb
Validation Extension -
Postgre JSON FunctionsPostgreSQL JSON Updatepg_jsonschema
supabase • Updated 2023 Aug 28 11:1
add json column
ALTER TABLE table ADD COLUMN "jsisonb" jsonb not null default '{"datas": [{},{}]}'; ALTER TABLE table ADD COLUMN "jeison" json not null default '{"datas": [{},{}]}'::jsonb;
SELECT jsonb->'datas' FROM table;
remove column
ALTER TABLE "table" DROP COLUMN "jeison"
size limit
- 255mb jsonb
- 1gb json (text)
