Data types

The following table lists the primitive and compound data types in YSQL.

Data type	Alias	Description
array		One-dimensional or multidimensional rectilinear array of any data type payload
bigint	int8	Signed eight-byte integer
bigserial	serial8	Autoincrementing eight-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 on a plane
date		Calendar date (year, month, day)
double precision	float8	Double precision floating-point number (8 bytes)
`inet` ¹		IPv4 or IPv6 host address
integer	int, int4	Signed four-byte integer
interval [ fields ] [ (p) ]		Time span
json ¹		Textual JSON data
jsonb ¹		JSON data, stored as decomposed binary
`line` ¹		Infinite line on a plane
`lseg` ¹		Line segment on a plane
`macaddr` ¹		Media Access Control (MAC) address
`macaddr8` ¹		Media Access Control (MAC) address (EUI-64 format)
money		Currency amount
numeric [ (p, s) ]	decimal [ (p, s) ]	Exact fixed-point numeric
`path` ¹		Geometric path on a plane
`pg_lsn` ¹		Log Sequence Number
`point` ¹		Geometric point
`polygon` ¹		Closed geometric path
real	float4	Floating-point number (4 bytes)
smallint	int2	Signed two-byte integer
int4range		`integer` range
int8range		`bigint` range
numrange		`numeric` range
tsrange		`timestamp without time zone` range
tstzrange		`timestamp with time zone` range
daterange		`date` range
smallserial	serial2	Autoincrementing two-byte integer
serial	serial4	Autoincrementing four-byte integer
text		Variable-length character string
time [ (p) ] [ without time zone ]		Time of day (no time zone)
time [ (p) ] with time zone	timetz	Time of day, including time zone
timestamp [ (p) ] [ without time zone ]		Date and time (no time zone)
timestamp [ (p) ] with time zone	timestamptz	Date and time, including time zone
`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.