PostgreSQL has a rich set of native data types available to
users. Users may add new types to PostgreSQL using the CREATE
TYPE command. Table 8-1 shows all built-in general-purpose data
types. Most of the alternative names listed in the "Aliases"
column are the names used internally by PostgreSQL for
historical reasons. In addition, some internally used or
deprecated types are available, but they are not listed here.
Table 8-1. Data Types |bigint||int8||signed eight-byte integer|
|bigserial||serial8||autoincrementing eight-byte integer|
|bit||fixed-length bit string| |bit
varying(n)||varbit(n)||variable-length bit string|
|boolean||bool||logical Boolean (true/false)| |box||rectangular
box in the plane| |character varying(n)||varchar(n)||variable-
length character string| |character(n)||char(n)||fixed-length
character string| |cidr||IPv4 or IPv6 network address|
|circle||circle in the plane| |date||calendar date (year, month,
day)| |double precision||float8||double precision floating-point
number| |inet||IPv4 o