Supported data types PostgreSQL

Name	Aliases	Beschreibung
bigint	int8	signed eight-byte integer
bigserial	serial8	autoincrementing eight-byte integer
bit		fixed-length bit string
boolean	bool	logical Boolean (true/false)
bytea		binary data (“byte array”)
character	char [ (n) ]	fixed-length character string
character varying	varchar [ (n) ]	variable-length character string
date		calendar date (year, month, day)
double precision	float8	double precision floating-point number (8 bytes)
integer	int, int4	signed four-byte integer
money		currency amount
numeric	decimal [ (p, s) ]	exact numeric of selectable precision
real	float4	single precision floating-point number (4 bytes)
smallint	int2	signed two-byte integer
smallserial	serial2	autoincrementing two-byte integer
serial	serial4	autoincrementing four-byte integer
text		variable-length character string
time		time of day (no time zone)
time without time zone	timetz	time of day, including time zone
timestamp		date and time (no time zone)
timestamp with time zone	timestamptz	date and time, including time zone
uuid		universally unique identifier
xml		XML data

With PostgreSQL you are flexible - the following data types are supported in connection with your PostgreSQL database.