pg_operator
The catalog pg_operator stores information about operators.
pg_operator Columns
| Column Type | Description |
|---|---|
oid oid | Row identifier |
oprname name | Name of the operator |
oprnamespace oid (references pg_namespace.oid) | The OID of the namespace that contains this operator |
oprowner oid (references pg_authid.oid) | Owner of the operator |
oprkind char | b = infix operator (“both”), or l = prefix operator (“left”) |
oprcanmerge bool | This operator supports merge joins |
oprcanhash bool | This operator supports hash joins |
oprleft oid (references pg_type.oid) | Type of the left operand (zero for a prefix operator) |
oprright oid (references pg_type.oid) | Type of the right operand |
oprresult oid (references pg_type.oid) | Type of the result (zero for a not-yet-defined “shell” operator) |
oprcom oid (references pg_operator.oid) | Commutator of this operator (zero if none) |
oprnegate oid (references pg_operator.oid) | Negator of this operator (zero if none) |
oprcode regproc (references pg_proc.oid) | Function that implements this operator (zero for a not-yet-defined “shell” operator) |
oprrest regproc (references pg_proc.oid) | Restriction selectivity estimation function for this operator (zero if none) |
oprjoin regproc (references pg_proc.oid) | Join selectivity estimation function for this operator (zero if none) |