ACLITEM	ACLITEM - access control list
ACLITEM_ARRAY	ACLITEM[]
ANY	ANY - pseudo-type representing any type
ANYARRAY	ANYARRAY - pseudo-type representing a polymorphic array type
ANYELEMENT	ANYELEMENT - pseudo-type representing a polymorphic base type
ANYENUM	ANYENUM - pseudo-type representing a polymorphic base type that is an enum
ANYNONARRAY	ANYNONARRAY - pseudo-type representing a polymorphic base type that is not an array
ANY_RANGE	ANYRANGE - pseudo-type representing a polymorphic base type that is a range
BIT	BIT - fixed-length bit string
BIT_ARRAY	BIT[]
BOOL	BOOL - boolean, 'true'/'false'
BOOL_ARRAY	BOOL[]
BOX	BOX - geometric box '(lower left,upper right)'
BOX_ARRAY	BOX[]
BPCHAR	BPCHAR - char(length), blank-padded string, fixed storage length
BPCHAR_ARRAY	BPCHAR[]
BYTEA	BYTEA - variable-length string, binary values escaped
BYTEA_ARRAY	BYTEA[]
CHAR	CHAR - single character
CHAR_ARRAY	CHAR[]
CID	CID - command identifier type, sequence in transaction id
CIDR	CIDR - network IP address/netmask, network address
CIDR_ARRAY	CIDR[]
CID_ARRAY	CID[]
CIRCLE	CIRCLE - geometric circle '(center,radius)'
CIRCLE_ARRAY	CIRCLE[]
CSTRING	CSTRING - C-style string
CSTRING_ARRAY	CSTRING[]
DATE	DATE - date
DATE_ARRAY	DATE[]
DATE_RANGE	DATERANGE - range of dates
DATE_RANGE_ARRAY	DATERANGE[]
EVENT_TRIGGER	EVENT_TRIGGER - pseudo-type for the result of an event trigger function
FDW_HANDLER	FDW_HANDLER - pseudo-type for the result of an FDW handler function
FLOAT4	FLOAT4 - single-precision floating point number, 4-byte storage
FLOAT4_ARRAY	FLOAT4[]
FLOAT8	FLOAT8 - double-precision floating point number, 8-byte storage
FLOAT8_ARRAY	FLOAT8[]
GTS_VECTOR	GTSVECTOR - GiST index internal text representation for text search
GTS_VECTOR_ARRAY	GTSVECTOR[]
INDEX_AM_HANDLER	INDEX_AM_HANDLER - pseudo-type for the result of an index AM handler function
INET	INET - IP address/netmask, host address, netmask optional
INET_ARRAY	INET[]
INT2	INT2 - -32 thousand to 32 thousand, 2-byte storage
INT2_VECTOR	INT2VECTOR - array of int2, used in system tables
INT2_ARRAY	INT2[]
INT2_VECTOR_ARRAY	INT2VECTOR[]
INT4	INT4 - -2 billion to 2 billion integer, 4-byte storage
INT4_ARRAY	INT4[]
INT4_RANGE	INT4RANGE - range of integers
INT4_RANGE_ARRAY	INT4RANGE[]
INT8	INT8 - ~18 digit integer, 8-byte storage
INT8_ARRAY	INT8[]
INT8_RANGE	INT8RANGE - range of bigints
INT8_RANGE_ARRAY	INT8RANGE[]
INTERNAL	INTERNAL - pseudo-type representing an internal data structure
INTERVAL	INTERVAL - @ <number> <units>, time interval
INTERVAL_ARRAY	INTERVAL[]
JSON	JSON - JSON stored as text
JSONB	JSONB - Binary JSON
JSONB_ARRAY	JSONB[]
JSONPATH	JSONPATH - JSON path
JSONPATH_ARRAY	JSONPATH[]
JSON_ARRAY	JSON[]
LANGUAGE_HANDLER	LANGUAGE_HANDLER - pseudo-type for the result of a language handler function
LINE	LINE - geometric line
LINE_ARRAY	LINE[]
LSEG	LSEG - geometric line segment '(pt1,pt2)'
LSEG_ARRAY	LSEG[]
MACADDR	MACADDR - XX:XX:XX:XX:XX:XX, MAC address
MACADDR8	MACADDR8 - XX:XX:XX:XX:XX:XX:XX:XX, MAC address
MACADDR8_ARRAY	MACADDR8[]
MACADDR_ARRAY	MACADDR[]
MONEY	MONEY - monetary amounts, $d,ddd.cc
MONEY_ARRAY	MONEY[]
NAME	NAME - 63-byte type for storing system identifiers
NAME_ARRAY	NAME[]
NUMERIC	NUMERIC - numeric(precision, decimal), arbitrary precision number
NUMERIC_ARRAY	NUMERIC[]
NUM_RANGE	NUMRANGE - range of numerics
NUM_RANGE_ARRAY	NUMRANGE[]
OID	OID - object identifier(oid), maximum 4 billion
OID_ARRAY	OID[]
OID_VECTOR	OIDVECTOR - array of oids, used in system tables
OID_VECTOR_ARRAY	OIDVECTOR[]
OPAQUE	OPAQUE - obsolete, deprecated pseudo-type
PATH	PATH - geometric path '(pt1,...)'
PATH_ARRAY	PATH[]
PG_DDL_COMMAND	PG_DDL_COMMAND - internal type for passing CollectedCommand
PG_DEPENDENCIES	PG_DEPENDENCIES - multivariate dependencies
PG_LSN	PG_LSN - PostgreSQL LSN datatype
PG_LSN_ARRAY	PG_LSN[]
PG_MCV_LIST	PG_MCV_LIST - multivariate MCV list
PG_NDISTINCT	PG_NDISTINCT - multivariate ndistinct coefficients
PG_NODE_TREE	PG_NODE_TREE - string representing an internal node tree
POINT	POINT - geometric point '(x, y)'
POINT_ARRAY	POINT[]
POLYGON	POLYGON - geometric polygon '(pt1,...)'
POLYGON_ARRAY	POLYGON[]
RECORD	RECORD - pseudo-type representing any composite type
RECORD_ARRAY	RECORD[]
REFCURSOR	REFCURSOR - reference to cursor (portal name)
REFCURSOR_ARRAY	REFCURSOR[]
REGCLASS	REGCLASS - registered class
REGCLASS_ARRAY	REGCLASS[]
REGCONFIG	REGCONFIG - registered text search configuration
REGCONFIG_ARRAY	REGCONFIG[]
REGDICTIONARY	REGDICTIONARY - registered text search dictionary
REGDICTIONARY_ARRAY	REGDICTIONARY[]
REGNAMESPACE	REGNAMESPACE - registered namespace
REGNAMESPACE_ARRAY	REGNAMESPACE[]
REGOPER	REGOPER - registered operator
REGOPERATOR	REGOPERATOR - registered operator (with args)
REGOPERATOR_ARRAY	REGOPERATOR[]
REGOPER_ARRAY	REGOPER[]
REGPROC	REGPROC - registered procedure
REGPROCEDURE	REGPROCEDURE - registered procedure (with args)
REGPROCEDURE_ARRAY	REGPROCEDURE[]
REGPROC_ARRAY	REGPROC[]
REGROLE	REGROLE - registered role
REGROLE_ARRAY	REGROLE[]
REGTYPE	REGTYPE - registered type
REGTYPE_ARRAY	REGTYPE[]
TABLE_AM_HANDLER	TABLE_AM_HANDLER
TEXT	TEXT - variable-length string, no limit specified
TEXT_ARRAY	TEXT[]
TID	TID - (block, offset), physical location of tuple
TID_ARRAY	TID[]
TIME	TIME - time of day
TIMESTAMP	TIMESTAMP - date and time
TIMESTAMPTZ	TIMESTAMPTZ - date and time with time zone
TIMESTAMPTZ_ARRAY	TIMESTAMPTZ[]
TIMESTAMP_ARRAY	TIMESTAMP[]
TIMETZ	TIMETZ - time of day with time zone
TIMETZ_ARRAY	TIMETZ[]
TIME_ARRAY	TIME[]
TRIGGER	TRIGGER - pseudo-type for the result of a trigger function
TSM_HANDLER	TSM_HANDLER - pseudo-type for the result of a tablesample method function
TSQUERY	TSQUERY - query representation for text search
TSQUERY_ARRAY	TSQUERY[]
TSTZ_RANGE	TSTZRANGE - range of timestamps with time zone
TSTZ_RANGE_ARRAY	TSTZRANGE[]
TS_RANGE	TSRANGE - range of timestamps without time zone
TS_RANGE_ARRAY	TSRANGE[]
TS_VECTOR	TSVECTOR - text representation for text search
TS_VECTOR_ARRAY	TSVECTOR[]
TXID_SNAPSHOT	TXID_SNAPSHOT - txid snapshot
TXID_SNAPSHOT_ARRAY	TXID_SNAPSHOT[]
UNKNOWN	UNKNOWN - pseudo-type representing an undetermined type
UUID	UUID - UUID datatype
UUID_ARRAY	UUID[]
VARBIT	VARBIT - variable-length bit string
VARBIT_ARRAY	VARBIT[]
VARCHAR	VARCHAR - varchar(length), non-blank-padded string, variable storage length
VARCHAR_ARRAY	VARCHAR[]
VOID	VOID - pseudo-type for the result of a function with no real result
XID	XID - transaction id
XID_ARRAY	XID[]
XML	XML - XML content
XML_ARRAY	XML[]

[−][src]Module libpq::types

Structs

Enums

Constants