Expand description
Well-known PostgreSQL type OIDs.
Constants§
- ACLITEM
- access control list
- 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
- BOOL
- boolean, format ‘t’/‘f’
- BOX
- geometric box, format ‘lower left point,upper right point’
- BPCHAR
- ‘char(length)’ blank-padded string, fixed storage length
- BYTEA
- variable-length string, binary values escaped
- CHAR
- single character
- CID
- command identifier type, sequence in transaction id
- CIDR
- network IP address/netmask, network address
- CIRCLE
- geometric circle, format ‘<center point,radius>’
- CSTRING
- C-style string
- DATE
- date
- DATEMULTIRANGE
- multirange of dates
- DATERANGE
- range of dates
- 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
- FLOAT8
- double-precision floating point number, 8-byte storage
- GTSVECTOR
- GiST index internal text representation for text search
- INDEX_
AM_ HANDLER - pseudo-type for the result of an index AM handler function
- INET
- IP address/netmask, host address, netmask optional
- INT2
- -32 thousand to 32 thousand, 2-byte storage
- INT4
- -2 billion to 2 billion integer, 4-byte storage
- INT8
- ~18 digit integer, 8-byte storage
- INT2VECTOR
- array of int2, used in system tables
- INT4MULTIRANGE
- multirange of integers
- INT4RANGE
- range of integers
- INT8MULTIRANGE
- multirange of bigints
- INT8RANGE
- range of bigints
- INTERNAL
- pseudo-type representing an internal data structure
- INTERVAL
- time interval, format ‘number units …’
- JSON
- JSON stored as text
- JSONB
- Binary JSON
- JSONPATH
- JSON path
- LANGUAGE_
HANDLER - pseudo-type for the result of a language handler function
- LINE
- geometric line, formats ‘{A,B,C}’/‘[point1,point2]’
- LSEG
- geometric line segment, format ‘[point1,point2]’
- MACADDR
- XX:XX:XX:XX:XX:XX, MAC address
- MACADD
R8 - XX:XX:XX:XX:XX:XX:XX:XX, MAC address
- MONEY
- monetary amounts, $d,ddd.cc
- NAME
- 63-byte type for storing system identifiers
- NUMERIC
- ‘numeric(precision, scale)’ arbitrary precision number
- NUMMULTIRANGE
- multirange of numerics
- NUMRANGE
- range of numerics
- OID
- object identifier(oid), maximum 4 billion
- OIDVECTOR
- array of oids, used in system tables
- PATH
- geometric path, format ‘(point1,…)’
- PG_
ATTRIBUTE - pg_attribute system catalog
- PG_
BRIN_ BLOOM_ SUMMARY - pseudo-type representing BRIN bloom summary
- PG_
BRIN_ MINMAX_ MULTI_ SUMMARY - pseudo-type representing BRIN minmax-multi summary
- PG_
CLASS - pg_class system catalog
- PG_
DDL_ COMMAND - internal type for passing CollectedCommand
- PG_
DEPENDENCIES - multivariate dependencies
- PG_LSN
- PostgreSQL LSN
- PG_
MCV_ LIST - multivariate MCV list
- PG_
NDISTINCT - multivariate ndistinct coefficients
- PG_
NODE_ TREE - string representing an internal node tree
- PG_PROC
- pg_proc system catalog
- PG_
SNAPSHOT - transaction snapshot
- PG_TYPE
- pg_type system catalog
- POINT
- geometric point, format ‘(x,y)’
- POLYGON
- geometric polygon, format ‘(point1,…)’
- RECORD
- pseudo-type representing any composite type
- RECORD_
ARRAY - array of records
- REFCURSOR
- reference to cursor (portal name)
- REGCLASS
- registered class
- REGCOLLATION
- registered collation
- REGCONFIG
- registered text search configuration
- REGDATABASE
- registered database
- REGDICTIONARY
- registered text search dictionary
- REGNAMESPACE
- registered namespace
- REGOPER
- registered operator
- REGOPERATOR
- registered operator (with args)
- REGPROC
- registered procedure
- REGPROCEDURE
- registered procedure (with args)
- REGROLE
- registered role
- REGTYPE
- registered type
- TABLE_
AM_ HANDLER - pseudo-type for the result of a table AM handler function
- TEXT
- variable-length string, no limit specified
- TID
- tuple physical location, format ‘(block,offset)’
- TIME
- time of day
- TIMESTAMP
- date and time
- TIMESTAMPTZ
- date and time with time zone
- TIMETZ
- time of day with time zone
- TRIGGER
- pseudo-type for the result of a trigger function
- TSMULTIRANGE
- multirange of timestamps without time zone
- TSM_
HANDLER - pseudo-type for the result of a tablesample method function
- TSQUERY
- query representation for text search
- TSRANGE
- range of timestamps without time zone
- TSTZMULTIRANGE
- multirange of timestamps with time zone
- TSTZRANGE
- range of timestamps with time zone
- TSVECTOR
- text representation for text search
- TXID_
SNAPSHOT - transaction snapshot
- UNKNOWN
- pseudo-type representing an undetermined type
- UUID
- UUID
- VARBIT
- variable-length bit string
- VARCHAR
- ‘varchar(length)’ non-blank-padded string, variable storage length
- VOID
- pseudo-type for the result of a function with no real result
- XID
- transaction id
- XID8
- full transaction id
- XML
- XML content