System Catalogs / System catalogs
pg_operator
Read the PG 18 manualThe catalog pg_operator stores information about operators.
Reading PG 18current·documented in 24 of 24 versions, 7.4 to 20
- Kind
- System catalogs
- Columns in this snapshot
- 15
- Definition source
- English manual
- Metadata snapshot
- 18.6
Columns 15
As listed in the PostgreSQL 18 manual.
| Column | Type | Description / reference |
|---|---|---|
oid | oidNOT NULL | Row identifier |
oprname | nameNOT NULL | Name of the operator |
oprnamespace | oidNOT NULL | The OID of the namespace that contains this operator pg_namespace.oid |
oprowner | oidNOT NULL | Owner of the operator pg_authid.oid |
oprkind | charNOT NULL | b = infix operator (“both”), or l = prefix operator (“left”) |
oprcanmerge | boolNOT NULL | This operator supports merge joins |
oprcanhash | boolNOT NULL | This operator supports hash joins |
oprleft | oidNOT NULL | Type of the left operand (zero for a prefix operator) pg_type.oid |
oprright | oidNOT NULL | Type of the right operand pg_type.oid |
oprresult | oidNOT NULL | Type of the result (zero for a not-yet-defined “shell” operator) pg_type.oid |
oprcom | oidNOT NULL | Commutator of this operator (zero if none) pg_operator.oid |
oprnegate | oidNOT NULL | Negator of this operator (zero if none) pg_operator.oid |
oprcode | regprocNOT NULL | Function that implements this operator (zero for a not-yet-defined “shell” operator) pg_proc.oid |
oprrest | regprocNOT NULL | Restriction selectivity estimation function for this operator (zero if none) pg_proc.oid |
oprjoin | regprocNOT NULL | Join selectivity estimation function for this operator (zero if none) pg_proc.oid |
Column history across versions
Version history 11
Definition snapshot: english-manuals:cc8a2c02ffd08ed9eb4ec05c830… · English manual source