Character

PostgreSQL Data Type Character

Character

  • In most cases, you should use text or character varying data type
Type Description
character varying(n)varchar(n) Variation length with limited size
character(n)char(n) Fixed length and padding with the space
text variation length and unlimited sizes

JSON

The biggest storage size is 255MB. The difference between the json and jsonb is the storage method and process performance, otherwise, everything is the same.

Type Description
json Storage the json data in the original json format and order
jsonb Storage the binary json data, it will re-order the json as binary order and increase the process performance, support the index search query
  • tsvector
  • tsquery

Reference

JSON