Wiki / Data Types

PostgreSQL data types, aliases, representations and versioned definitions, with links to operators and index support.

Reading PostgreSQL 18.6.

Find an entry GroupAll groupsBit strings (2)Boolean (1)Character strings (11)Date and time (9)Geometric (7)Internal and special-purpose (2)JSON (3)Multiranges (6)Network addresses (2)Numeric (7)Object and transaction identifiers (18)Other built-in types (12)Pseudo-types (26)Ranges (6)SQL conveniences (3)Text search (2)Type families (4) Apply

121 entries; 114 recorded in PostgreSQL 18.6.

• bit Bit strings

  fixed-length bit string

  1011121314151617181920
• bit varying Bit strings

  variable-length bit string

  1011121314151617181920
• boolean Boolean

  logical Boolean (true/false)

  1011121314151617181920
• "char" Character strings

  single-byte internal type

  1011121314151617181920
• character Character strings

  fixed-length character string

  1011121314151617181920
• character varying Character strings

  variable-length character string

  1011121314151617181920
• name Character strings

  internal type for object names

  1011121314151617181920
• pg_brin_bloom_summary Character strings

  pseudo-type representing BRIN bloom summary

  1011121314151617181920
• pg_brin_minmax_multi_summary Character strings

  pseudo-type representing BRIN minmax-multi summary

  1011121314151617181920
• pg_dependencies Character strings

  multivariate dependencies

  1011121314151617181920
• pg_mcv_list Character strings

  multivariate MCV list

  1011121314151617181920
• pg_ndistinct Character strings

  multivariate ndistinct coefficients

  1011121314151617181920
• pg_node_tree Character strings

  string representing an internal node tree

  1011121314151617181920
• text Character strings

  variable-length character string

  1011121314151617181920
• abstime Date and time not in 18

  Not recorded in the selected version.

  1011121314151617181920
• date Date and time

  calendar date (year, month, day)

  1011121314151617181920
• interval Date and time

  time span

  1011121314151617181920
• reltime Date and time not in 18

  Not recorded in the selected version.

  1011121314151617181920
• time with time zone Date and time

  time of day, including time zone

  1011121314151617181920
• time without time zone Date and time

  time of day (no time zone)

  1011121314151617181920
• timestamp with time zone Date and time

  date and time, including time zone

  1011121314151617181920
• timestamp without time zone Date and time

  date and time (no time zone)

  1011121314151617181920
• tinterval Date and time not in 18

  Not recorded in the selected version.

  1011121314151617181920
• box Geometric

  rectangular box on a plane

  1011121314151617181920
• circle Geometric

  circle on a plane

  1011121314151617181920
• line Geometric

  infinite line on a plane

  1011121314151617181920
• lseg Geometric

  line segment on a plane

  1011121314151617181920
• path Geometric

  geometric path on a plane

  1011121314151617181920
• point Geometric

  geometric point on a plane

  1011121314151617181920
• polygon Geometric

  closed geometric path on a plane

  1011121314151617181920
• int2vector Internal and special-purpose

  array of int2, used in system tables

  1011121314151617181920
• oidvector Internal and special-purpose

  array of oids, used in system tables

  1011121314151617181920
• json JSON

  textual JSON data

  1011121314151617181920
• jsonb JSON

  binary JSON data, decomposed

  1011121314151617181920
• jsonpath JSON

  JSON path

  1011121314151617181920
• datemultirange Multiranges

  multirange of dates

  1011121314151617181920
• int4multirange Multiranges

  multirange of integers

  1011121314151617181920
• int8multirange Multiranges

  multirange of bigints

  1011121314151617181920
• nummultirange Multiranges

  multirange of numerics

  1011121314151617181920
• tsmultirange Multiranges

  multirange of timestamps without time zone

  1011121314151617181920
• tstzmultirange Multiranges

  multirange of timestamps with time zone

  1011121314151617181920
• cidr Network addresses

  IPv4 or IPv6 network address

  1011121314151617181920
• inet Network addresses

  IPv4 or IPv6 host address

  1011121314151617181920
• bigint Numeric

  signed eight-byte integer

  1011121314151617181920
• double precision Numeric

  double precision floating-point number (8 bytes)

  1011121314151617181920
• integer Numeric

  signed four-byte integer

  1011121314151617181920
• money Numeric

  currency amount

  1011121314151617181920
• numeric Numeric

  exact numeric of selectable precision

  1011121314151617181920
• real Numeric

  single precision floating-point number (4 bytes)

  1011121314151617181920
• smallint Numeric

  signed two-byte integer

  1011121314151617181920
• cid Object and transaction identifiers

  command identifier type, sequence in transaction id

  1011121314151617181920
• oid Object and transaction identifiers

  numeric object identifier

  1011121314151617181920
• oid8 Object and transaction identifiers not in 18

  Not recorded in the selected version.

  1011121314151617181920
• regclass Object and transaction identifiers

  relation name

  1011121314151617181920
• regcollation Object and transaction identifiers

  collation name

  1011121314151617181920
• regconfig Object and transaction identifiers

  text search configuration

  1011121314151617181920
• regdatabase Object and transaction identifiers not in 18

  Not recorded in the selected version.

  1011121314151617181920
• regdictionary Object and transaction identifiers

  text search dictionary

  1011121314151617181920
• regnamespace Object and transaction identifiers

  namespace name

  1011121314151617181920
• regoper Object and transaction identifiers

  operator name

  1011121314151617181920
• regoperator Object and transaction identifiers

  operator with argument types

  1011121314151617181920
• regproc Object and transaction identifiers

  function name

  1011121314151617181920
• regprocedure Object and transaction identifiers

  function with argument types

  1011121314151617181920
• regrole Object and transaction identifiers

  role name

  1011121314151617181920
• regtype Object and transaction identifiers

  data type name

  1011121314151617181920
• tid Object and transaction identifiers

  tuple physical location, format '(block,offset)'

  1011121314151617181920
• xid Object and transaction identifiers

  transaction id

  1011121314151617181920
• xid8 Object and transaction identifiers

  full transaction id

  1011121314151617181920
• aclitem Other built-in types

  access control list

  1011121314151617181920
• bytea Other built-in types

  binary data ( “ byte array ” )

  1011121314151617181920
• gtsvector Other built-in types

  GiST index internal text representation for text search

  1011121314151617181920
• macaddr Other built-in types

  MAC (Media Access Control) address

  1011121314151617181920
• macaddr8 Other built-in types

  MAC (Media Access Control) address (EUI-64 format)

  1011121314151617181920
• pg_lsn Other built-in types

  PostgreSQL Log Sequence Number

  1011121314151617181920
• pg_snapshot Other built-in types

  user-level transaction ID snapshot

  1011121314151617181920
• refcursor Other built-in types

  reference to cursor (portal name)

  1011121314151617181920
• smgr Other built-in types not in 18

  Not recorded in the selected version.

  1011121314151617181920
• txid_snapshot Other built-in types

  user-level transaction ID snapshot (deprecated; see pg_snapshot )

  1011121314151617181920
• uuid Other built-in types

  universally unique identifier

  1011121314151617181920
• xml Other built-in types

  XML data

  1011121314151617181920
• any Pseudo-types

  Indicates that a function accepts any input data type.

  1011121314151617181920
• anyarray Pseudo-types

  Indicates that a function accepts any array data type (see Section 36.2.5 ).

  1011121314151617181920
• anycompatible Pseudo-types

  Indicates that a function accepts any data type, with automatic promotion of multiple arguments to a common data type (see Section 36.2.5 ).

  1011121314151617181920
• anycompatiblearray Pseudo-types

  Indicates that a function accepts any array data type, with automatic promotion of multiple arguments to a common data type (see Section 36.2.5 ).

  1011121314151617181920
• anycompatiblemultirange Pseudo-types

  Indicates that a function accepts any multirange data type, with automatic promotion of multiple arguments to a common data type (see Section 36.2.5 and Section 8.17 ).

  1011121314151617181920
• anycompatiblenonarray Pseudo-types

  Indicates that a function accepts any non-array data type, with automatic promotion of multiple arguments to a common data type (see Section 36.2.5 ).

  1011121314151617181920
• anycompatiblerange Pseudo-types

  Indicates that a function accepts any range data type, with automatic promotion of multiple arguments to a common data type (see Section 36.2.5 and Section 8.17 ).

  1011121314151617181920
• anyelement Pseudo-types

  Indicates that a function accepts any data type (see Section 36.2.5 ).

  1011121314151617181920
• anyenum Pseudo-types

  Indicates that a function accepts any enum data type (see Section 36.2.5 and Section 8.7 ).

  1011121314151617181920
• anymultirange Pseudo-types

  Indicates that a function accepts any multirange data type (see Section 36.2.5 and Section 8.17 ).

  1011121314151617181920
• anynonarray Pseudo-types

  Indicates that a function accepts any non-array data type (see Section 36.2.5 ).

  1011121314151617181920
• anyrange Pseudo-types

  Indicates that a function accepts any range data type (see Section 36.2.5 and Section 8.17 ).

  1011121314151617181920
• cstring Pseudo-types

  Indicates that a function accepts or returns a null-terminated C string.

  1011121314151617181920
• event_trigger Pseudo-types

  An event trigger function is declared to return event_trigger.

  1011121314151617181920
• fdw_handler Pseudo-types

  A foreign-data wrapper handler is declared to return fdw_handler .

  1011121314151617181920
• index_am_handler Pseudo-types

  An index access method handler is declared to return index_am_handler .

  1011121314151617181920
• internal Pseudo-types

  Indicates that a function accepts or returns a server-internal data type.

  1011121314151617181920
• language_handler Pseudo-types

  A procedural language call handler is declared to return language_handler .

  1011121314151617181920
• opaque Pseudo-types not in 18

  Not recorded in the selected version.

  1011121314151617181920
• pg_ddl_command Pseudo-types

  Identifies a representation of DDL commands that is available to event triggers.

  1011121314151617181920
• record Pseudo-types

  Identifies a function taking or returning an unspecified row type.

  1011121314151617181920
• table_am_handler Pseudo-types

  A table access method handler is declared to return table_am_handler .

  1011121314151617181920
• trigger Pseudo-types

  A trigger function is declared to return trigger.

  1011121314151617181920
• tsm_handler Pseudo-types

  A tablesample method handler is declared to return tsm_handler .

  1011121314151617181920
• unknown Pseudo-types

  Identifies a not-yet-resolved type, e.g., of an undecorated string literal.

  1011121314151617181920
• void Pseudo-types

  Indicates that a function returns no value.

  1011121314151617181920
• daterange Ranges

  range of dates

  1011121314151617181920
• int4range Ranges

  range of integers

  1011121314151617181920
• int8range Ranges

  range of bigints

  1011121314151617181920
• numrange Ranges

  range of numerics

  1011121314151617181920
• tsrange Ranges

  range of timestamps without time zone

  1011121314151617181920
• tstzrange Ranges

  range of timestamps with time zone

  1011121314151617181920
• bigserial SQL conveniences

  autoincrementing eight-byte integer

  1011121314151617181920
• serial SQL conveniences

  autoincrementing four-byte integer

  1011121314151617181920
• smallserial SQL conveniences

  autoincrementing two-byte integer

  1011121314151617181920
• tsquery Text search

  text search query

  1011121314151617181920
• tsvector Text search

  text search document

  1011121314151617181920
• Arrays Type families

  PostgreSQL allows columns of a table to be defined as variable-length multidimensional arrays. Arrays of any built-in or user-defined base type, enum type, composite type, range type, or domain can be created.

  1011121314151617181920
• Composite types Type families

  A composite type represents the structure of a row or record; it is essentially just a list of field names and their data types. PostgreSQL allows composite types to be used in many of the same ways that simple types can be used. For example, a colu…

  1011121314151617181920
• Domains Type families

  A domain is a user-defined data type that is based on another underlying type . Optionally, it can have constraints that restrict its valid values to a subset of what the underlying type would allow. Otherwise it behaves like the underlying type — f…

  1011121314151617181920
• Enumerated types Type families

  Enumerated (enum) types are data types that comprise a static, ordered set of values. They are equivalent to the enum types supported in a number of programming languages. An example of an enum type might be the days of the week, or a set of status …

  1011121314151617181920

RecordedFirst recordedInterface or attribute changeNo longer recorded

Squares indicate presence in sampled builds, not first introduction. Select a square for the same-version definition and sources.

Export JSON

Reading this collection

Named built-in types, pseudo-types and type families have distinct entries. Serial forms are SQL conveniences. User-defined types and extension types are outside this core inventory. A manual definition is not a measured catalog property.