Character
PostgreSQL Data Type Character
Categories:
Character
- In most cases, you should use
textorcharacter varyingdata 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