PostgreSQL Data Types Reference

PostgreSQL bigint is an integer data type provided by PostgreSQL that is typically used to store integers that exceed the range of standard integer types.

bigserial data type is a data type in PostgreSQL database used for automatically generating unique identifiers.

The boolean data type in PostgreSQL is used to store boolean values, which represent true or false.

box is a data type in PostgreSQL used to represent a rectangular region on a plane.

The char data type is a data type in PostgreSQL used to store fixed-length strings.

cidr is a data type in PostgreSQL used to store IPv4 or IPv6 addresses and subnet masks.

The PostgreSQL circle data type represents a circle on a plane.

The citext data type in PostgreSQL is a case-insensitive text type that allows ignoring case when performing text comparisons.

In PostgreSQL, date is a data type used to store date values.

In PostgreSQL, decimal is a fixed precision numeric data type that allows storing high-precision numbers with specified precision and scale.

The PostgreSQL double precision data type is a floating-point number with a precision of 15-17 digits, offering higher precision and a wider range compared to the float data type.

The PostgreSQL enum data type is a data type used to define enumerated types.

The PostgreSQL inet data type is used for storing and processing IPv4 or IPv6 addresses.

In PostgreSQL, integer is used to define the integer data type.

The PostgreSQL interval data type represents the difference between two dates or times.

The PostgreSQL json data type can be used to store and query unstructured data.

The PostgreSQL jsonb data type can be used to store and query unstructured data.

In PostgreSQL, the line data type can be used for storing and querying spatial data.

In PostgreSQL, the lseg data type can be used for storing and querying spatial data.

The PostgreSQL numeric data type is used to store numbers with arbitrary precision.

PostgreSQL path can store paths in two-dimensional planes, such as curves or polylines composed of multiple line segments.

The PostgreSQL point type is a data type in PostgreSQL used to store points in a two-dimensional Cartesian coordinate system.

PostgreSQL polygon data type is used to store closed planar polygons.

The real data type in PostgreSQL is a floating-point type that can store single-precision floating-point numbers (32 bits).

The serial data type in PostgreSQL is a special data type used for automatically generating sequential numbers.

In PostgreSQL, smallint is a fixed-length integer data type used to store integers in the range of -32768 to 32767.

In PostgreSQL, the text data type is used to store variable-length strings.

In PostgreSQL, the time data type is used to store time values, including hours, minutes, seconds, and microseconds.

Learn what PostgreSQL timestamp without time zone stores, why input offsets are ignored, its range, and when to use timestamptz.

Learn how PostgreSQL timestamptz converts input to UTC, displays values in the session time zone, and does not retain the original zone.

Learn what PostgreSQL timetz stores, why an offset without a date cannot model daylight-saving rules, and when to use time or timestamptz instead.

PostgreSQL’s uuid type stores 128-bit values, and PostgreSQL 18 adds native UUIDv7 generation. Use a PRIMARY KEY or UNIQUE constraint to reject duplicates.

varchar is a commonly used data type in PostgreSQL for storing variable-length strings.