The catalog pg_operator
stores information about operators.
See CREATE OPERATOR
and Section 33.12, “User-Defined Operators” for more information.
Table 43.25. pg_operator
Columns
Name | Type | References | Description |
---|---|---|---|
oprname |
name |
Name of the operator | |
oprnamespace |
oid |
|
The OID of the namespace that contains this operator |
oprowner |
oid |
|
Owner of the operator |
oprkind |
char |
b = infix (“both”), l = prefix
(“left”), r = postfix (“right”)
|
|
oprcanhash |
bool |
This operator supports hash joins | |
oprleft |
oid |
|
Type of the left operand |
oprright |
oid |
|
Type of the right operand |
oprresult |
oid |
|
Type of the result |
oprcom |
oid |
|
Commutator of this operator, if any |
oprnegate |
oid |
|
Negator of this operator, if any |
oprlsortop |
oid |
|
If this operator supports merge joins, the operator that sorts
the type of the left-hand operand (L<L )
|
oprrsortop |
oid |
|
If this operator supports merge joins, the operator that sorts
the type of the right-hand operand (R<R )
|
oprltcmpop |
oid |
|
If this operator supports merge joins, the less-than operator that
compares the left and right operand types (L<R )
|
oprgtcmpop |
oid |
|
If this operator supports merge joins, the greater-than operator that
compares the left and right operand types (L>R )
|
oprcode |
regproc |
|
Function that implements this operator |
oprrest |
regproc |
|
Restriction selectivity estimation function for this operator |
oprjoin |
regproc |
|
Join selectivity estimation function for this operator |
Unused column contain zeroes. For example, oprleft
is zero for a prefix operator.