Postgres JSON JSONB

Creator
Creator
Seonglae ChoSeonglae Cho
Created
Created
2020 Dec 11 4:18
Editor
Edited
Edited
2023 Jun 27 16:19
Refs
Refs
The JSON data type in PostgreSQL stores the value as plain text, as opposed to binary representation. If you simply want to store and retrieve a JSON representation, using JSON will take less disk space and less time to build from its input representation. However, if you want to do any operations on the JSON value, you should prefer the JSONB data type described below

just use jsonb

Postgres JSON
Postgres JSONB
 
 
 

Recommendations