Module oid 

The built-in types of PostgreSQL: one for each entry of pg_type.dat, and one for each array type that an entry asks for with array_type_oid, as genbki.pl makes them.

cargo xtask pgtype makes this file from vendor/postgres-19/src/include/catalog/pg_type.dat. Do not edit it.

Constants

ACLITEM

aclitem, access control list.

ACLITEM_ARRAY

_aclitem, the array of aclitem.

ANY

any, pseudo-type representing any type.

ANYARRAY

anyarray, pseudo-type representing a polymorphic array type.

ANYCOMPATIBLE

anycompatible, pseudo-type representing a polymorphic common type.

ANYCOMPATIBLEARRAY

anycompatiblearray, pseudo-type representing an array of polymorphic common type elements.

ANYCOMPATIBLEMULTIRANGE

anycompatiblemultirange, pseudo-type representing a multirange over a polymorphic common type.

ANYCOMPATIBLENONARRAY

anycompatiblenonarray, pseudo-type representing a polymorphic common type that is not an array.

ANYCOMPATIBLERANGE

anycompatiblerange, pseudo-type representing a range over a polymorphic common type.

ANYELEMENT

anyelement, pseudo-type representing a polymorphic base type.

ANYENUM

anyenum, pseudo-type representing a polymorphic base type that is an enum.

ANYMULTIRANGE

anymultirange, pseudo-type representing a polymorphic base type that is a multirange.

ANYNONARRAY

anynonarray, pseudo-type representing a polymorphic base type that is not an array.

ANYRANGE

anyrange, pseudo-type representing a range over a polymorphic base type.

BIT

bit, fixed-length bit string.

BIT_ARRAY

_bit, the array of bit.

BOOL

bool, boolean, format ‘t’/‘f’.

BOOL_ARRAY

_bool, the array of bool.

BOX

box, geometric box, format ‘lower left point,upper right point’.

BOX_ARRAY

_box, the array of box.

BPCHAR

bpchar, ‘char(length)’ blank-padded string, fixed storage length.

BPCHAR_ARRAY

_bpchar, the array of bpchar.

BYTEA

bytea, variable-length string, binary values escaped.

BYTEA_ARRAY

_bytea, the array of bytea.

CHAR

char, single character.

CHAR_ARRAY

_char, the array of char.

CID

cid, command identifier type, sequence in transaction id.

CIDR

cidr, network IP address/netmask, network address.

CIDR_ARRAY

_cidr, the array of cidr.

CID_ARRAY

_cid, the array of cid.

CIRCLE

circle, geometric circle, format ‘<center point,radius>’.

CIRCLE_ARRAY

_circle, the array of circle.

CSTRING

cstring, C-style string.

CSTRING_ARRAY

_cstring, the array of cstring.

DATE

date, date.

DATEMULTIRANGE

datemultirange, multirange of dates.

DATEMULTIRANGE_ARRAY

_datemultirange, the array of datemultirange.

DATERANGE

daterange, range of dates.

DATERANGE_ARRAY

_daterange, the array of daterange.

DATE_ARRAY

_date, the array of date.

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.

FLOAT8

float8, double-precision floating point number, 8-byte storage.

FLOAT4_ARRAY

_float4, the array of float4.

FLOAT8_ARRAY

_float8, the array of float8.

GTSVECTOR

gtsvector, GiST index internal text representation for text search.

GTSVECTOR_ARRAY

_gtsvector, the array of 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, the array of inet.

INT2

int2, -32 thousand to 32 thousand, 2-byte storage.

INT4

int4, -2 billion to 2 billion integer, 4-byte storage.

INT8

int8, ~18 digit integer, 8-byte storage.

INT2VECTOR

int2vector, array of int2, used in system tables.

INT2VECTOR_ARRAY

_int2vector, the array of int2vector.

INT2_ARRAY

_int2, the array of int2.

INT4MULTIRANGE

int4multirange, multirange of integers.

INT4MULTIRANGE_ARRAY

_int4multirange, the array of int4multirange.

INT4RANGE

int4range, range of integers.

INT4RANGE_ARRAY

_int4range, the array of int4range.

INT4_ARRAY

_int4, the array of int4.

INT8MULTIRANGE

int8multirange, multirange of bigints.

INT8MULTIRANGE_ARRAY

_int8multirange, the array of int8multirange.

INT8RANGE

int8range, range of bigints.

INT8RANGE_ARRAY

_int8range, the array of int8range.

INT8_ARRAY

_int8, the array of int8.

INTERNAL

internal, pseudo-type representing an internal data structure.

INTERVAL

interval, time interval, format ‘number units …’.

INTERVAL_ARRAY

_interval, the array of interval.

JSON

json, JSON stored as text.

JSONB

jsonb, Binary JSON.

JSONB_ARRAY

_jsonb, the array of jsonb.

JSONPATH

jsonpath, JSON path.

JSONPATH_ARRAY

_jsonpath, the array of jsonpath.

JSON_ARRAY

_json, the array of json.

LANGUAGE_HANDLER

language_handler, pseudo-type for the result of a language handler function.

LINE

line, geometric line, formats ‘{A,B,C}’/‘[point1,point2]’.

LINE_ARRAY

_line, the array of line.

LSEG

lseg, geometric line segment, format ‘[point1,point2]’.

LSEG_ARRAY

_lseg, the array of 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, the array of macaddr8.

MACADDR_ARRAY

_macaddr, the array of macaddr.

MONEY

money, monetary amounts, $d,ddd.cc.

MONEY_ARRAY

_money, the array of money.

NAME

name, 63-byte type for storing system identifiers.

NAME_ARRAY

_name, the array of name.

NUMERIC

numeric, ‘numeric(precision, scale)’ arbitrary precision number.

NUMERIC_ARRAY

_numeric, the array of numeric.

NUMMULTIRANGE

nummultirange, multirange of numerics.

NUMMULTIRANGE_ARRAY

_nummultirange, the array of nummultirange.

NUMRANGE

numrange, range of numerics.

NUMRANGE_ARRAY

_numrange, the array of numrange.

OID

oid, object identifier(oid), maximum 4 billion.

OID8

oid8, object identifier(oid8), 8 bytes.

OID8_ARRAY

_oid8, the array of oid8.

OIDVECTOR

oidvector, array of oids, used in system tables.

OIDVECTOR_ARRAY

_oidvector, the array of oidvector.

OID_ARRAY

_oid, the array of oid.

PATH

path, geometric path, format ‘(point1,…)’.

PATH_ARRAY

_path, the array of path.

PG_ATTRIBUTE

pg_attribute.

PG_ATTRIBUTE_ARRAY

_pg_attribute, the array of pg_attribute.

PG_BRIN_BLOOM_SUMMARY

pg_brin_bloom_summary, pseudo-type representing BRIN bloom summary.

PG_BRIN_MINMAX_MULTI_SUMMARY

pg_brin_minmax_multi_summary, pseudo-type representing BRIN minmax-multi summary.

PG_CLASS

pg_class.

PG_CLASS_ARRAY

_pg_class, the array of pg_class.

PG_DDL_COMMAND

pg_ddl_command, internal type for passing CollectedCommand.

PG_DEPENDENCIES

pg_dependencies, multivariate dependencies.

PG_LSN

pg_lsn, PostgreSQL LSN.

PG_LSN_ARRAY

_pg_lsn, the array of 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.

PG_PROC

pg_proc.

PG_PROC_ARRAY

_pg_proc, the array of pg_proc.

PG_SNAPSHOT

pg_snapshot, transaction snapshot.

PG_SNAPSHOT_ARRAY

_pg_snapshot, the array of pg_snapshot.

PG_TYPE

pg_type.

PG_TYPE_ARRAY

_pg_type, the array of pg_type.

POINT

point, geometric point, format ‘(x,y)’.

POINT_ARRAY

_point, the array of point.

POLYGON

polygon, geometric polygon, format ‘(point1,…)’.

POLYGON_ARRAY

_polygon, the array of polygon.

RECORD

record, pseudo-type representing any composite type.

RECORD_ARRAY

_record.

REFCURSOR

refcursor, reference to cursor (portal name).

REFCURSOR_ARRAY

_refcursor, the array of refcursor.

REGCLASS

regclass, registered class.

REGCLASS_ARRAY

_regclass, the array of regclass.

REGCOLLATION

regcollation, registered collation.

REGCOLLATION_ARRAY

_regcollation, the array of regcollation.

REGCONFIG

regconfig, registered text search configuration.

REGCONFIG_ARRAY

_regconfig, the array of regconfig.

REGDATABASE

regdatabase, registered database.

REGDATABASE_ARRAY

_regdatabase, the array of regdatabase.

REGDICTIONARY

regdictionary, registered text search dictionary.

REGDICTIONARY_ARRAY

_regdictionary, the array of regdictionary.

REGNAMESPACE

regnamespace, registered namespace.

REGNAMESPACE_ARRAY

_regnamespace, the array of regnamespace.

REGOPER

regoper, registered operator.

REGOPERATOR

regoperator, registered operator (with args).

REGOPERATOR_ARRAY

_regoperator, the array of regoperator.

REGOPER_ARRAY

_regoper, the array of regoper.

REGPROC

regproc, registered procedure.

REGPROCEDURE

regprocedure, registered procedure (with args).

REGPROCEDURE_ARRAY

_regprocedure, the array of regprocedure.

REGPROC_ARRAY

_regproc, the array of regproc.

REGROLE

regrole, registered role.

REGROLE_ARRAY

_regrole, the array of regrole.

REGTYPE

regtype, registered type.

REGTYPE_ARRAY

_regtype, the array of regtype.

TABLE_AM_HANDLER

table_am_handler, pseudo-type for the result of a table AM handler function.

TEXT

text, variable-length string, no limit specified.

TEXT_ARRAY

_text, the array of text.

TID

tid, tuple physical location, format ‘(block,offset)’.

TID_ARRAY

_tid, the array of tid.

TIME

time, time of day.

TIMESTAMP

timestamp, date and time.

TIMESTAMPTZ

timestamptz, date and time with time zone.

TIMESTAMPTZ_ARRAY

_timestamptz, the array of timestamptz.

TIMESTAMP_ARRAY

_timestamp, the array of timestamp.

TIMETZ

timetz, time of day with time zone.

TIMETZ_ARRAY

_timetz, the array of timetz.

TIME_ARRAY

_time, the array of time.

TRIGGER

trigger, pseudo-type for the result of a trigger function.

TSMULTIRANGE

tsmultirange, multirange of timestamps without time zone.

TSMULTIRANGE_ARRAY

_tsmultirange, the array of tsmultirange.

TSM_HANDLER

tsm_handler, pseudo-type for the result of a tablesample method function.

TSQUERY

tsquery, query representation for text search.

TSQUERY_ARRAY

_tsquery, the array of tsquery.

TSRANGE

tsrange, range of timestamps without time zone.

TSRANGE_ARRAY

_tsrange, the array of tsrange.

TSTZMULTIRANGE

tstzmultirange, multirange of timestamps with time zone.

TSTZMULTIRANGE_ARRAY

_tstzmultirange, the array of tstzmultirange.

TSTZRANGE

tstzrange, range of timestamps with time zone.

TSTZRANGE_ARRAY

_tstzrange, the array of tstzrange.

TSVECTOR

tsvector, text representation for text search.

TSVECTOR_ARRAY

_tsvector, the array of tsvector.

TXID_SNAPSHOT

txid_snapshot, transaction snapshot.

TXID_SNAPSHOT_ARRAY

_txid_snapshot, the array of txid_snapshot.

UNKNOWN

unknown, pseudo-type representing an undetermined type.

UUID

uuid, UUID.

UUID_ARRAY

_uuid, the array of uuid.

VARBIT

varbit, variable-length bit string.

VARBIT_ARRAY

_varbit, the array of varbit.

VARCHAR

varchar, ‘varchar(length)’ non-blank-padded string, variable storage length.

VARCHAR_ARRAY

_varchar, the array of varchar.

VOID

void, pseudo-type for the result of a function with no real result.

XID

xid, transaction id.

XID8

xid8, full transaction id.

XID8_ARRAY

_xid8, the array of xid8.

XID_ARRAY

_xid, the array of xid.

XML

xml, XML content.

XML_ARRAY

_xml, the array of xml.