Wiki / Data Types

Definitions for PostgreSQL 18

• "char"Character strings10 – 20

  single-byte internal type

  1011121314151617181920
• ArraysType families10 – 20

  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 typesType families10 – 20

  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 column of a table can be declared to be of a composite type.

  1011121314151617181920
• DomainsType families10 – 20

  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 — for example, any operator or function that can be applied to the underlying type will work on the domain type. The underlying type can be any built-in or user-defined base type, enum type, array type, composite type, range type, or another domain.

  1011121314151617181920
• Enumerated typesType families10 – 20

  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 values for a piece of data.

  1011121314151617181920
• aclitemOther built-in types10 – 20

  access control list

  1011121314151617181920
• anyPseudo-types10 – 20

  Indicates that a function accepts any input data type.

  1011121314151617181920
• anyarrayPseudo-types10 – 20

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

  1011121314151617181920
• anycompatiblePseudo-types13 – 20

  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
• anycompatiblearrayPseudo-types13 – 20

  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
• anycompatiblemultirangePseudo-types14 – 20

  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
• anycompatiblenonarrayPseudo-types13 – 20

  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
• anycompatiblerangePseudo-types13 – 20

  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
• anyelementPseudo-types10 – 20

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

  1011121314151617181920
• anyenumPseudo-types10 – 20

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

  1011121314151617181920
• anymultirangePseudo-types14 – 20

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

  1011121314151617181920
• anynonarrayPseudo-types10 – 20

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

  1011121314151617181920
• anyrangePseudo-types10 – 20

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

  1011121314151617181920
• bigintNumeric10 – 20

  signed eight-byte integer

  1011121314151617181920
• bigserialSQL conveniences10 – 20

  autoincrementing eight-byte integer

  1011121314151617181920
• bitBit strings10 – 20

  fixed-length bit string

  1011121314151617181920
• bit varyingBit strings10 – 20

  variable-length bit string

  1011121314151617181920
• booleanBoolean10 – 20

  logical Boolean (true/false)

  1011121314151617181920
• boxGeometric10 – 20

  rectangular box on a plane

  1011121314151617181920
• byteaOther built-in types10 – 20

  binary data ( “ byte array ” )

  1011121314151617181920
• characterCharacter strings10 – 20

  fixed-length character string

  1011121314151617181920
• character varyingCharacter strings10 – 20

  variable-length character string

  1011121314151617181920
• cidObject and transaction identifiers10 – 20

  command identifier type, sequence in transaction id

  1011121314151617181920
• cidrNetwork addresses10 – 20

  IPv4 or IPv6 network address

  1011121314151617181920
• circleGeometric10 – 20

  circle on a plane

  1011121314151617181920
• cstringPseudo-types10 – 20

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

  1011121314151617181920
• dateDate and time10 – 20

  calendar date (year, month, day)

  1011121314151617181920
• datemultirangeMultiranges14 – 20

  multirange of dates

  1011121314151617181920
• daterangeRanges10 – 20

  range of dates

  1011121314151617181920
• double precisionNumeric10 – 20

  double precision floating-point number (8 bytes)

  1011121314151617181920
• event_triggerPseudo-types10 – 20

  An event trigger function is declared to return event_trigger.

  1011121314151617181920
• fdw_handlerPseudo-types10 – 20

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

  1011121314151617181920
• gtsvectorOther built-in types10 – 20

  GiST index internal text representation for text search

  1011121314151617181920
• index_am_handlerPseudo-types10 – 20

  An index access method handler is declared to return index_am_handler .

  1011121314151617181920
• inetNetwork addresses10 – 20

  IPv4 or IPv6 host address

  1011121314151617181920
• int2vectorInternal and special-purpose10 – 20

  array of int2, used in system tables

  1011121314151617181920
• int4multirangeMultiranges14 – 20

  multirange of integers

  1011121314151617181920
• int4rangeRanges10 – 20

  range of integers

  1011121314151617181920
• int8multirangeMultiranges14 – 20

  multirange of bigints

  1011121314151617181920
• int8rangeRanges10 – 20

  range of bigints

  1011121314151617181920
• integerNumeric10 – 20

  signed four-byte integer

  1011121314151617181920
• internalPseudo-types10 – 20

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

  1011121314151617181920
• intervalDate and time10 – 20

  time span

  1011121314151617181920
• jsonJSON10 – 20

  textual JSON data

  1011121314151617181920
• jsonbJSON10 – 20

  binary JSON data, decomposed

  1011121314151617181920
• jsonpathJSON12 – 20

  JSON path

  1011121314151617181920
• language_handlerPseudo-types10 – 20

  A procedural language call handler is declared to return language_handler .

  1011121314151617181920
• lineGeometric10 – 20

  infinite line on a plane

  1011121314151617181920
• lsegGeometric10 – 20

  line segment on a plane

  1011121314151617181920
• macaddrOther built-in types10 – 20

  MAC (Media Access Control) address

  1011121314151617181920
• macaddr8Other built-in types10 – 20

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

  1011121314151617181920
• moneyNumeric10 – 20

  currency amount

  1011121314151617181920
• nameCharacter strings10 – 20

  internal type for object names

  1011121314151617181920
• numericNumeric10 – 20

  exact numeric of selectable precision

  1011121314151617181920
• nummultirangeMultiranges14 – 20

  multirange of numerics

  1011121314151617181920
• numrangeRanges10 – 20

  range of numerics

  1011121314151617181920
• oidObject and transaction identifiers10 – 20

  numeric object identifier

  1011121314151617181920
• oidvectorInternal and special-purpose10 – 20

  array of oids, used in system tables

  1011121314151617181920
• pathGeometric10 – 20

  geometric path on a plane

  1011121314151617181920
• pg_brin_bloom_summaryCharacter strings14 – 20

  pseudo-type representing BRIN bloom summary

  1011121314151617181920
• pg_brin_minmax_multi_summaryCharacter strings14 – 20

  pseudo-type representing BRIN minmax-multi summary

  1011121314151617181920
• pg_ddl_commandPseudo-types10 – 20

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

  1011121314151617181920
• pg_dependenciesCharacter strings10 – 20

  multivariate dependencies

  1011121314151617181920
• pg_lsnOther built-in types10 – 20

  PostgreSQL Log Sequence Number

  1011121314151617181920
• pg_mcv_listCharacter strings12 – 20

  multivariate MCV list

  1011121314151617181920
• pg_ndistinctCharacter strings10 – 20

  multivariate ndistinct coefficients

  1011121314151617181920
• pg_node_treeCharacter strings10 – 20

  string representing an internal node tree

  1011121314151617181920
• pg_snapshotOther built-in types13 – 20

  user-level transaction ID snapshot

  1011121314151617181920
• pointGeometric10 – 20

  geometric point on a plane

  1011121314151617181920
• polygonGeometric10 – 20

  closed geometric path on a plane

  1011121314151617181920
• realNumeric10 – 20

  single precision floating-point number (4 bytes)

  1011121314151617181920
• recordPseudo-types10 – 20

  Identifies a function taking or returning an unspecified row type.

  1011121314151617181920
• refcursorOther built-in types10 – 20

  reference to cursor (portal name)

  1011121314151617181920
• regclassObject and transaction identifiers10 – 20

  relation name

  1011121314151617181920
• regcollationObject and transaction identifiers13 – 20

  collation name

  1011121314151617181920
• regconfigObject and transaction identifiers10 – 20

  text search configuration

  1011121314151617181920
• regdictionaryObject and transaction identifiers10 – 20

  text search dictionary

  1011121314151617181920
• regnamespaceObject and transaction identifiers10 – 20

  namespace name

  1011121314151617181920
• regoperObject and transaction identifiers10 – 20

  operator name

  1011121314151617181920
• regoperatorObject and transaction identifiers10 – 20

  operator with argument types

  1011121314151617181920
• regprocObject and transaction identifiers10 – 20

  function name

  1011121314151617181920
• regprocedureObject and transaction identifiers10 – 20

  function with argument types

  1011121314151617181920
• regroleObject and transaction identifiers10 – 20

  role name

  1011121314151617181920
• regtypeObject and transaction identifiers10 – 20

  data type name

  1011121314151617181920
• serialSQL conveniences10 – 20

  autoincrementing four-byte integer

  1011121314151617181920
• smallintNumeric10 – 20

  signed two-byte integer

  1011121314151617181920
• smallserialSQL conveniences10 – 20

  autoincrementing two-byte integer

  1011121314151617181920
• table_am_handlerPseudo-types12 – 20

  A table access method handler is declared to return table_am_handler .

  1011121314151617181920
• textCharacter strings10 – 20

  variable-length character string

  1011121314151617181920
• tidObject and transaction identifiers10 – 20

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

  1011121314151617181920
• time with time zoneDate and time10 – 20

  time of day, including time zone

  1011121314151617181920
• time without time zoneDate and time10 – 20

  time of day (no time zone)

  1011121314151617181920
• timestamp with time zoneDate and time10 – 20

  date and time, including time zone

  1011121314151617181920
• timestamp without time zoneDate and time10 – 20

  date and time (no time zone)

  1011121314151617181920
• triggerPseudo-types10 – 20

  A trigger function is declared to return trigger.

  1011121314151617181920
• tsm_handlerPseudo-types10 – 20

  A tablesample method handler is declared to return tsm_handler .

  1011121314151617181920
• tsmultirangeMultiranges14 – 20

  multirange of timestamps without time zone

  1011121314151617181920
• tsqueryText search10 – 20

  text search query

  1011121314151617181920
• tsrangeRanges10 – 20

  range of timestamps without time zone

  1011121314151617181920
• tstzmultirangeMultiranges14 – 20

  multirange of timestamps with time zone

  1011121314151617181920
• tstzrangeRanges10 – 20

  range of timestamps with time zone

  1011121314151617181920
• tsvectorText search10 – 20

  text search document

  1011121314151617181920
• txid_snapshotOther built-in types10 – 20

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

  1011121314151617181920
• unknownPseudo-types10 – 20

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

  1011121314151617181920
• uuidOther built-in types10 – 20

  universally unique identifier

  1011121314151617181920
• voidPseudo-types10 – 20

  Indicates that a function returns no value.

  1011121314151617181920
• xidObject and transaction identifiers10 – 20

  transaction id

  1011121314151617181920
• xid8Object and transaction identifiers13 – 20

  full transaction id

  1011121314151617181920
• xmlOther built-in types10 – 20

  XML data

  1011121314151617181920