Module libpq::types [−][src]
Structs
Enums
Constants
ACLITEM - access control list
ACLITEM[]
ANY - pseudo-type representing any type
ANYARRAY - pseudo-type representing a polymorphic array type
ANYCOMPATIBLE - pseudo-type representing a polymorphic common type
ANYCOMPATIBLEARRAY - pseudo-type representing an array of polymorphic common type elements
ANYCOMPATIBLEMULTIRANGE - pseudo-type representing a multirange over a polymorphic common type
ANYCOMPATIBLENONARRAY - pseudo-type representing a polymorphic common type that is not an array
ANYCOMPATIBLERANGE - pseudo-type representing a range over a polymorphic common type
ANYELEMENT - pseudo-type representing a polymorphic base type
ANYENUM - pseudo-type representing a polymorphic base type that is an enum
ANYMULTIRANGE - pseudo-type representing a polymorphic base type that is a multirange
ANYNONARRAY - pseudo-type representing a polymorphic base type that is not an array
ANYRANGE - pseudo-type representing a range over a polymorphic base type
BIT - fixed-length bit string
BIT[]
BOOL - boolean, 'true'/'false'
BOOL[]
BOX - geometric box '(lower left,upper right)'
BOX[]
BPCHAR - char(length), blank-padded string, fixed storage length
BPCHAR[]
BYTEA - variable-length string, binary values escaped
BYTEA[]
CHAR - single character
CHAR[]
CID - command identifier type, sequence in transaction id
CIDR - network IP address/netmask, network address
CIDR[]
CID[]
CIRCLE - geometric circle '(center,radius)'
CIRCLE[]
CSTRING - C-style string
CSTRING[]
DATE - date
DATEMULTIRANGE - multirange of dates
DATEMULTIRANGE[]
DATE[]
DATERANGE - range of dates
DATERANGE[]
EVENT_TRIGGER - pseudo-type for the result of an event trigger function
FDW_HANDLER - pseudo-type for the result of an FDW handler function
FLOAT4 - single-precision floating point number, 4-byte storage
FLOAT4[]
FLOAT8 - double-precision floating point number, 8-byte storage
FLOAT8[]
GTSVECTOR - GiST index internal text representation for text search
GTSVECTOR[]
INDEX_AM_HANDLER - pseudo-type for the result of an index AM handler function
INET - IP address/netmask, host address, netmask optional
INET[]
INT2 - -32 thousand to 32 thousand, 2-byte storage
INT2[]
INT2VECTOR - array of int2, used in system tables
INT2VECTOR[]
INT4 - -2 billion to 2 billion integer, 4-byte storage
INT4MULTIRANGE - multirange of integers
INT4MULTIRANGE[]
INT4[]
INT4RANGE - range of integers
INT4RANGE[]
INT8 - ~18 digit integer, 8-byte storage
INT8MULTIRANGE - multirange of bigints
INT8MULTIRANGE[]
INT8[]
INT8RANGE - range of bigints
INT8RANGE[]
INTERNAL - pseudo-type representing an internal data structure
INTERVAL - @ <number> <units>, time interval
INTERVAL[]
JSON - JSON stored as text
JSONB - Binary JSON
JSONB[]
JSONPATH - JSON path
JSONPATH[]
JSON[]
LANGUAGE_HANDLER - pseudo-type for the result of a language handler function
LINE - geometric line
LINE[]
LSEG - geometric line segment '(pt1,pt2)'
LSEG[]
MACADDR - XX:XX:XX:XX:XX:XX, MAC address
MACADDR8 - XX:XX:XX:XX:XX:XX:XX:XX, MAC address
MACADDR8[]
MACADDR[]
MONEY - monetary amounts, $d,ddd.cc
MONEY[]
NAME - 63-byte type for storing system identifiers
NAME[]
NUMERIC - numeric(precision, decimal), arbitrary precision number
NUMERIC[]
NUMMULTIRANGE - multirange of numerics
NUMMULTIRANGE[]
NUMRANGE - range of numerics
NUMRANGE[]
OID - object identifier(oid), maximum 4 billion
OID[]
OIDVECTOR - array of oids, used in system tables
OIDVECTOR[]
OPAQUE - obsolete, deprecated pseudo-type
PATH - geometric path '(pt1,…)'
PATH[]
PG_BRIN_BLOOM_SUMMARY - BRIN bloom summary
PG_BRIN_MINMAX_MULTI_SUMMARY - BRIN minmax-multi summary
PG_DDL_COMMAND - internal type for passing CollectedCommand
PG_DEPENDENCIES - multivariate dependencies
PG_LSN - PostgreSQL LSN datatype
PG_LSN[]
PG_MCV_LIST - multivariate MCV list
PG_NDISTINCT - multivariate ndistinct coefficients
PG_NODE_TREE - string representing an internal node tree
PG_SNAPSHOT - snapshot
PG_SNAPSHOT[]
POINT - geometric point '(x, y)'
POINT[]
POLYGON - geometric polygon '(pt1,…)'
POLYGON[]
RECORD - pseudo-type representing any composite type
RECORD[]
REFCURSOR - reference to cursor (portal name)
REFCURSOR[]
REGCLASS - registered class
REGCLASS[]
REGCOLLATION - registered collation
REGCOLLATION[]
REGCONFIG - registered text search configuration
REGCONFIG[]
REGDICTIONARY - registered text search dictionary
REGDICTIONARY[]
REGNAMESPACE - registered namespace
REGNAMESPACE[]
REGOPER - registered operator
REGOPERATOR - registered operator (with args)
REGOPERATOR[]
REGOPER[]
REGPROC - registered procedure
REGPROCEDURE - registered procedure (with args)
REGPROCEDURE[]
REGPROC[]
REGROLE - registered role
REGROLE[]
REGTYPE - registered type
REGTYPE[]
TABLE_AM_HANDLER
TEXT - variable-length string, no limit specified
TEXT[]
TID - (block, offset), physical location of tuple
TID[]
TIME - time of day
TIMESTAMP - date and time
TIMESTAMPTZ - date and time with time zone
TIMESTAMPTZ[]
TIMESTAMP[]
TIMETZ - time of day with time zone
TIMETZ[]
TIME[]
TRIGGER - pseudo-type for the result of a trigger function
TSMULTIRANGE - multirange of timestamps without time zone
TSMULTIRANGE[]
TSM_HANDLER - pseudo-type for the result of a tablesample method function
TSQUERY - query representation for text search
TSQUERY[]
TSTZMULTIRANGE - multirange of timestamps with time zone
TSTZMULTIRANGE[]
TSTZRANGE - range of timestamps with time zone
TSTZRANGE[]
TSRANGE - range of timestamps without time zone
TSRANGE[]
TSVECTOR - text representation for text search
TSVECTOR[]
TXID_SNAPSHOT - txid snapshot
TXID_SNAPSHOT[]
UNKNOWN - pseudo-type representing an undetermined type
UUID - UUID datatype
UUID[]
VARBIT - variable-length bit string
VARBIT[]
VARCHAR - varchar(length), non-blank-padded string, variable storage length
VARCHAR[]
VOID - pseudo-type for the result of a function with no real result
XID - transaction id
XID8 - full transaction id
XID8[]
XID[]
XML - XML content
XML[]