The pg_operator catalog provides information about operator definitions.
| Column name | Data type | Description |
|---|---|---|
oid |
oid |
A row identifier. |
oprname |
name |
The name of the operator. |
oprnamespace |
oid (references pg_namespace.oid) |
The OID of the namespace containing the operator. |
oprowner |
oid (references pg_authid.oid) |
The OID of the role that owns the operator. |
oprkind |
char |
The type of the operator. The possible values are:
|
oprcanmerge |
bool |
Specifies whether the operator supports merge joins (TRUE) or not (FALSE). |
oprcanhash |
bool |
Specifies whether the operator supports hash joins (TRUE) or not (FALSE). |
oprleft |
oid (references pg_type.oid) |
The data type of the left operand.0 – Prefix operators. |
oprright |
oid (references pg_type.oid) |
The data type of the right operand. |
oprresult |
oid (references pg_type.oid) |
The data type of the result. 0 – A not-yet-defined “shell” operator. |
oprcom |
oid (references pg_operator.oid) |
The commutator operator. 0 – No operator exists. |
oprnegate |
oid (references pg_operator.oid) |
The negator operator. 0 – No negator operator exists. |
oprcode |
regproc (references pg_proc.oid) |
The function implementing this operator. 0 – A not-yet-defined “shell” operator. |
oprrest |
regproc (references pg_proc.oid) |
The restriction selectivity function. 0 – No selectivity function is defined. |
oprjoin |
regproc (references pg_proc.oid) |
The join selectivity function. 0 – No join selectivity function is defined. |