PostgreSQL Data Type Reference
A searchable reference of PostgreSQL data types - numeric, character, date/time, JSONB, arrays, UUID, and network types.
Search or browse PostgreSQL's data types by category, including some PostgreSQL-specific types like JSONB, arrays, and UUID.
For the equivalent reference on a different database, see the MySQL Data Type Reference or SQL Server Data Type Reference.
What Is This Reference?
A searchable list of PostgreSQL's data types, including several types less common in other databases - native array columns, the UUID type, network address types (inet, cidr), and both JSON and the more commonly recommended JSONB.
Why Use This Tool?
PostgreSQL's richer type system offers genuinely useful options (like JSONB's indexing support, versus plain JSON) that aren't obvious if you're used to a simpler type system. This reference explains what each one is actually good for.
How to Use It
- Search for a type name or keyword.
- Review its description and typical use case.
Limitations
This covers commonly-used PostgreSQL types - for full behavioral detail on any one type, PostgreSQL's own documentation remains authoritative.