Expand description
PostgreSQL type Object IDs (OIDs).
PostgreSQL identifies types by numeric OIDs. This module defines the well-known OIDs for built-in types.
Constants§
- BIT
- Bit string (fixed-length)
- BOOL
- Boolean type
- BOOL_
ARRAY - Boolean array
- BPCHAR
- Fixed-length character (bpchar)
- BYTEA
- Byte array (bytea)
- BYTEA_
ARRAY - Bytea array
- CHAR
- Single character (char)
- CHAR_
ARRAY - Char array
- CID
- Command ID (cid)
- CIDR
- IPv4/IPv6 CIDR address
- DATE
- Date (no time)
- DATERANGE
- Date range
- DATE_
ARRAY - Date array
- FLOAT4
- Single-precision floating point (float4/real)
- FLOAT8
- Double-precision floating point (float8/double precision)
- FLOA
T4_ ARRAY - Float4 array
- FLOA
T8_ ARRAY - Float8 array
- INET
- IPv4/IPv6 host address
- INT2
- 2-byte signed integer (int2/smallint)
- INT4
- 4-byte signed integer (int4/integer)
- INT8
- 8-byte signed integer (int8/bigint)
- INT2_
ARRAY - Int2 array
- INT4RANGE
- Integer range
- INT4_
ARRAY - Int4 array
- INT8RANGE
- Bigint range
- INT8_
ARRAY - Int8 array
- INTERVAL
- Time interval
- INTERVAL_
ARRAY - Interval array
- JSON
- JSON (text-based)
- JSONB
- JSONB (binary JSON)
- JSONB_
ARRAY - JSONB array
- JSON_
ARRAY - JSON array
- MACADDR
- MAC address (6 bytes)
- MONEY
- Money type
- NAME
- Name type (internal, 63-byte identifier)
- NAME_
ARRAY - Name array
- NUMERIC
- Arbitrary precision numeric
- NUMERIC_
ARRAY - Numeric array
- NUMRANGE
- Numeric range
- OID
- Object identifier (oid)
- OID_
ARRAY - OID array
- TEXT
- Variable-length text (text)
- TEXT_
ARRAY - Text array
- TIME
- Time without time zone
- TIMESTAMP
- Timestamp without time zone
- TIMESTAMPTZ
- Timestamp with time zone
- TIMESTAMPTZ_
ARRAY - Timestamptz array
- TIMESTAMP_
ARRAY - Timestamp array
- TIMETZ
- Time with time zone
- TIME_
ARRAY - Time array
- TSRANGE
- Timestamp range
- TSTZRANGE
- Timestamp with time zone range
- UNKNOWN
- Unknown type (used for NULL)
- UUID
- UUID (16-byte identifier)
- UUID_
ARRAY - UUID array
- VARBIT
- Bit string (variable-length)
- VARCHAR
- Variable-length character with limit (varchar)
- VARCHAR_
ARRAY - Varchar array
- VOID
- Void type (no return value)
- XID
- Transaction ID (xid)
- XML
- XML data
Functions§
- array_
oid - Get the array type OID for an element type OID.
- element_
oid - Get the array element OID for an array type OID.
- is_
array - Check if the OID represents an array type.
- type_
name - Get a human-readable name for a type OID.