51.34. pg_operator
The catalog
pg_operator
stores information about operators.
See
CREATE OPERATOR
and
Section 37.12
for more information.
Table 51.34.
pg_operator
Columns
| Name | Type | References | Description |
|---|---|---|---|
oid
|
oid
|
Row identifier (hidden attribute; must be explicitly selected) | |
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
"
)
|
|
oprcanmerge
|
bool
|
This operator supports merge joins | |
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 |
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 columns contain zeroes. For example,
oprleft
is zero for a prefix operator.