Get started with commonly-used Postgres data types with OptiTech's data type guides. For other data types that Postgres supports, visit the official Postgres Data Types documentation.
Array
Manage collections of elements using arrays
Boolean
Represent truth values in Postgres
Date and time
Work with date and time values in Postgres
Character
Work with text data in Postgres
JSON
Model JSON data in Postgres
Decimal
Work with exact numerical values in Postgres
Floating point
Work with float values in Postgres
Integer
Work with integers in Postgres
Tsvector
Optimize full-text search in Postgres with the tsvector data type
UUID
Work with UUIDs in Postgres