52.34. pg_operator

The catalog pg_operator stores information about operators. See CREATE OPERATOR and Section 38.14 for more information.

Table 52.34. 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)