PostgreSQL documentation recommends usage of jsonb
Validation Extension -
Postgre JSON FunctionsPostgreSQL JSON Updatepg_jsonschema
supabase • Updated 2023 Aug 28 11:1
add json column
remove column
postgresql: how to define a JSONB column with default value
Thanks for contributing an answer to Database Administrators Stack Exchange! Please be sure to answer the question. Provide details and share your research! Asking for help, clarification, or responding to other answers. Making statements based on opinion; back them up with references or personal experience. To learn more, see our tips on writing great answers.
https://dba.stackexchange.com/questions/207019/postgresql-how-to-define-a-jsonb-column-with-default-value
Postgresql JSON 데이터 타입 handling
꼭 한번씩 본인 로컬 DB에서 실습을 해보시기 바랍니다!! 이번 포스팅에서는 PostgreSQL에서 JSON 데이터 타입으로 작업하는 방법을 다룹니다. 또한, JSON 데이터 타입을 다루기 위한 PostgreSQL 연산자 혹은 함수를 소개해보고자 합니다. JSON은 Javascript Object Notation의 약자입니다. JSON은 키-값 쌍으로 이루어진 개방형 표준형식입니다. JSON은 주로 서버와 웹 어플리케이션 사이에 데이터 이동에 사용됩니다.
https://sas-study.tistory.com/268
info.enterprisedb.com
https://info.enterprisedb.com/rs/enterprisedb/images/EDB_White_Paper_Using_the_NoSQL_Features_in_Postgres.pdf
size limit
- 255mb jsonb
- 1gb json (text)
Size limit of JSON data type in PostgreSQL
Thanks for contributing an answer to Stack Overflow! Please be sure to answer the question. Provide details and share your research! Asking for help, clarification, or responding to other answers. Making statements based on opinion; back them up with references or personal experience. To learn more, see our tips on writing great answers.
https://stackoverflow.com/questions/12632871/size-limit-of-json-data-type-in-postgresql
