Home > APIs > YSQL >

Data types

Attention

This page documents an earlier version. Go to the latest version.

The following table lists the primitive types in YSQL.

Data type	Alias	Description
`BIGINT`	`INT8`	Signed 8-byte integer
`BIGSERIAL`	`SERIAL8`	Autoincrement 8-byte integer
`BIT [(n)]` ¹		Fixed-length bit string
`BIT VARYING [(n)]` ¹	`VARBIT [(n)]`	Variable-length bit string
`BOOLEAN`	`BOOL`	Logical boolean (true/false)
`BOX` ¹		Rectangular box
`BYTEA`		Binary data
`CHARACTER [(n)]`	`CHAR [(n)]`	Fixed-length character string
`CHARACTER VARYING [(n)]`	`VARCHAR [(n)]`	Variable-length character string
`CIDR` ¹		IPv4 or IPv6 network address
`CIRCLE` ¹		Circle
`DATE`		Date (year, month, day)
`DOUBLE PRECISION`	`FLOAT8`	Floating-point number (8 bytes)
`INET` ¹		IPv4 or IPv6 host address
`INTEGER`	`INT`, `INT4`	Signed 4-byte integer
`INTERVAL [fields] [(p)]`		Time span
`JSON` ¹		Textual JSON data
`JSONB`		Binary JSON data
`LINE` ¹		Infinite line
`LSEG` ¹		Line segment
`MACADDR` ¹		MAC address
`MACADDR8` ¹		MAC address (EUI-64 format)
`MONEY`		Currency amount
`NUMERIC [(p, s)]`	`DECIMAL [(p, s)]`	Exact fixed-point numeric
`PATH` ¹		Geometric path
`PG_LSN` ¹		Log Sequence Number
`POINT` ¹		Geometric point
`POLYGON` ¹		Closed geometric path
`REAL`	`FLOAT4`	Floating-point number (4 bytes)
`SMALLINT`	`INT2`	Signed 2-byte integer
`SMALLSERIAL`	`SERIAL2`	Autoincrement 2-byte integer
`SERIAL`	`SERIAL4`	Autoincrement 4-byte integer
`TEXT`		Variable-length character string
`TIME [(p)] [WITHOUT TIME ZONE]`		Time of day
`TIME [(p)] WITH TIME ZONE`	`TIMETZ`	Time of day
`TIMESTAMP [(p)] [WITHOUT TIME ZONE]`		Date and time
`TIMESTAMP [(p)] WITH TIME ZONE`	`TIMESTAMPTZ`	Date and time
`TSQUERY` ¹		Text search query
`TSVECTOR` ¹		Text search document
`TXID_SNAPSHOT` ¹		Transaction ID snapshot
`UUID`		Universally unique identifier
`XML` ²		XML data

¹ Table columns of this type cannot be part of an INDEX KEY.

² Under development.