Data Types for PostgreSQL

The following table lists the data type support for a PostgreSQL database.

The BINARY, NCHAR, NVARCHAR, TINYINT, and VARBINARY data types are not supported for data type definition.

For data source specific information about PostgreSQL data types, see the PostgreSQL database documentation.

Data Types for PostgreSQL
Data Type Definition Keyword1	PostgreSQL Data Type	Description	Data Type Returned
BIGINT	BIGINT	Large signed, exact whole number. OR Signed eight-byte integer.	BIGINT
2	BIGSERIAL	Autoincrementing eight-byte integer.	2
2	BIT(n)	Fixed-length bit string.	2
2	BIT VARYING(n)	Variable-length bit string.	2
2	BOOLEAN	Logical Boolean (true/false).	2
2	BOX	Rectangular box on a plane.	2
2	BYTEA	Binary data (byte array).	2
CHAR(n)	CHAR(n)	Fixed-length character string.	CHAR(n)
2	CIDR	IPv4 or IPv6 network address.	2
2	CIRCLE	Circle on a plane.	2
DATE	DATE	Date value.	DATE
DECIMAL\|NUMERIC(p,s)	NUMERIC(p,s)	Signed, fixed-point decimal number.	DECIMAL\|NUMERIC(p,s)
DOUBLE	DOUBLE PRECISION	Signed, double precision, floating-point number.	DOUBLE
FLOAT(p)	FLOAT(p)	Signed, single precision or double precision, floating-point number.	FLOAT(p)
2	INET	IPv4 or IPv6 host address.	2
INTEGER	INTEGER	Regular signed, exact whole number.	INTEGER
2	INTERVAL	Time span.	2
2	LINE	Infinite line on a plane.	2
2	LSEG	Line segment on a plane.	2
2	MACADDR	Media Access Control address.	2
2	MONEY	Currency amount.	2
2	PATH	Geometric path on a plane.	2
2	POINT	Geometric point on a plane.	2
2	POLYGON	Closed geometric path on a plane.	2
REAL	REAL	Signed, single precision floating-point number.	REAL
2	SERIAL	Autoincrementing four-byte integer.	2
SMALLINT	SMALLINT	Small signed, exact whole number.	SMALLINT
2	SMALL SERIAL	Autoincrementing two-byte integer.	2
2	TEXT	Variable-length character string.	2
TIME(p)	TIME(p)	Time value.	TIME(p)
TIMESTAMP(p)	TIMESTAMP(p)	Date and time value.	TIMESTAMP(p)
2	TSQUERY	Text search query.	2
2	TSVECTOR	Text search document.	2
2	TXID_SNAPSHOT	User-level transaction ID snapshot.	2
2	UUID	Universally unique identifier.	2
VARCHAR(n)	CHARACTER VARYING(n)	Varying-length character string.	VARCHAR(n)
2	XML	XML data.	2
1The CT_PRESERVE= connection argument, which controls how data types are mapped, can affect whether a data type can be defined. The values FORCE (default) and FORCE_COL_SIZE do not affect whether a data type can be defined. The values STRICT and SAFE can result in an error if the requested data type is not native to the data source, or the specified precision or scale is not within the data source range.
2The PostgreSQL data type cannot be defined, and when data is retrieved, the native data type is mapped to a similar data type.