Expand description
PostgreSQL type OID constants and information_schema helpers.
Constants§
- BOOL
- BOOL_
ARRAY - BYTEA
- BYTEA_
ARRAY - CHAR
- DATE
- DATE_
ARRAY - FLOAT4
- FLOAT8
- FLOA
T4_ ARRAY - FLOA
T8_ ARRAY - INT2
- INT4
- INT8
- INT2_
ARRAY - INT4_
ARRAY - INT8_
ARRAY - JSON
- JSONB
- JSONB_
ARRAY - JSON_
ARRAY - NAME
- NUMERIC
- NUMERIC_
ARRAY - TEXT
- TEXT_
ARRAY - TIME
- TIMESTAMP
- TIMESTAMPTZ
- TIMESTAMPTZ_
ARRAY - TIMESTAMP_
ARRAY - TIME_
ARRAY - UUID
- UUID_
ARRAY - VARCHAR
- VARCHAR_
ARRAY
Functions§
- array_
element_ oid - Returns the element OID for a known array OID, if any.
- is_
array_ oid - Returns true if the OID is a known array type we can decode.
- oid_
from_ information_ schema - Map an
information_schema.columns.data_type/udt_namepair to a type OID. Prefer queryingpg_attribute.atttypidwhen possible; this is a fallback.