Expand description
PostgreSQL type object identifiers and the binary/text format marker.
Structs§
- PgType
- A PostgreSQL type: its OID and canonical name.
Enums§
- Format
- The wire format of a value: text or binary.
Constants§
- BOOLOID
bool- BOOL_
ARRAY_ OID bool[]- BPCHAROID
bpchar(blank-paddedchar(n))- BPCHAR_
ARRAY_ OID bpchar[]- BYTEAOID
bytea- BYTEA_
ARRAY_ OID bytea[]- CIDROID
cidr- CIDR_
ARRAY_ OID cidr[]- DATEOID
date- DATE_
ARRAY_ OID date[]- FLOA
T4OID float4- FLOA
T4_ ARRAY_ OID float4[]- FLOA
T8OID float8- FLOA
T8_ ARRAY_ OID float8[]- INETOID
inet- INET_
ARRAY_ OID inet[]- INT2OID
int2- INT2_
ARRAY_ OID int2[]- INT4OID
int4- INT4_
ARRAY_ OID int4[]- INT8OID
int8- INT8_
ARRAY_ OID int8[]- INTERVALOID
interval- INTERVAL_
ARRAY_ OID interval[]- JSONBOID
jsonb- JSONB_
ARRAY_ OID jsonb[]- JSONOID
json- JSON_
ARRAY_ OID json[]- NAMEOID
name- NAME_
ARRAY_ OID name[]- NUMERICOID
numeric- NUMERIC_
ARRAY_ OID numeric[]- OIDOID
oid- TEXTOID
text- TEXT_
ARRAY_ OID text[]- TIMEOID
time- TIMESTAMPOID
timestamp(without time zone)- TIMESTAMPTZOID
timestamptz- TIMESTAMPTZ_
ARRAY_ OID timestamptz[]- TIMESTAMP_
ARRAY_ OID timestamp[]- TIMETZOID
timetz- TIMETZ_
ARRAY_ OID timetz[]- TIME_
ARRAY_ OID time[]- UUIDOID
uuid- UUID_
ARRAY_ OID uuid[]- VARCHAROID
varchar- VARCHAR_
ARRAY_ OID varchar[]
Statics§
- BOOL
bool- BYTEA
bytea- CIDR
cidr- DATE
date- FLOAT4
float4- FLOAT8
float8- INET
inet- INT2
int2- INT4
int4- INT8
int8- INTERVAL
interval- JSON
json- JSONB
jsonb- NUMERIC
numeric- TEXT
text- TIME
time- TIMESTAMP
timestamp- TIMESTAMPTZ
timestamptz- TIMETZ
timetz- UUID
uuid- VARCHAR
varchar
Functions§
- array_
element - Maps an array type OID back to its element type, when known.
- array_
oid - Returns the array type OID for the given element type.
- array_
oid_ checked - Like
array_oid, for use inconstcontexts where a missing mapping has to fail at compile time instead of silently declaring the wrong type. - is_
array - Returns
trueifoidis a known array type.
Type Aliases§
- Oid
- A PostgreSQL type object identifier (OID).