Character
PostgreSQL Data Type Character
Categories:
Character
- In most cases, you should use
text
orcharacter 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 |
Text Search
- tsvector
- tsquery