pg_operator
The catalog pg_operator stores information about operators. See CREATE OPERATOR and Section 36.14 for more information.
English manual coverage begins with PostgreSQL 7.4. Source history and runtime observations have their own recorded version boundaries.
Reading PG 18·Select a recorded version
- kind
- catalog
- lang
- en
- measured attributes
- true
- metadata release
- 18.6
- runtime columns
- oid, oprname, oprnamespace, oprowner, oprkind, oprcanmerge, oprcanhash, oprleft, oprright, oprresult, oprcom, oprnegate, oprcode, oprrest, oprjoin
- runtime verified
- false
- source
- english-manual
Definition PG 18
The catalog pg_operator stores information about operators. See CREATE OPERATOR and Section 36.14 for more information.
Catalog columns
| Column | Type | Nullability | Description |
|---|---|---|---|
| oid | oid | Not null | Row identifier |
| oprname | name | Not null | Name of the operator |
| oprnamespace | oid | Not null | The OID of the namespace that contains this operator |
| oprowner | oid | Not null | Owner of the operator |
| oprkind | char | Not null | b = infix operator (“both”), or l = prefix operator (“left”) |
| oprcanmerge | bool | Not null | This operator supports merge joins |
| oprcanhash | bool | Not null | This operator supports hash joins |
| oprleft | oid | Not null | Type of the left operand (zero for a prefix operator) |
| oprright | oid | Not null | Type of the right operand |
| oprresult | oid | Not null | Type of the result (zero for a not-yet-defined “shell” operator) |
| oprcom | oid | Not null | Commutator of this operator (zero if none) |
| oprnegate | oid | Not null | Negator of this operator (zero if none) |
| oprcode | regproc | Not null | Function that implements this operator (zero for a not-yet-defined “shell” operator) |
| oprrest | regproc | Not null | Restriction selectivity estimation function for this operator (zero if none) |
| oprjoin | regproc | Not null | Join selectivity estimation function for this operator (zero if none) |
Compare versions
Source references
Full definition and evidence JSON
Definition sources
center · PostgreSQL 18 · catalog-bilingual-repair:845601b6eef300a84d1a2f3985b826fe0f4b4ebefd17d44f389eb41f54d27177
Text language: en · catalog-bilingual-repair:845601b6eef300a84d1a2f3985b826fe0f4b4ebefd17d44f389eb41f54d27177