pg_operator - PolarDB - Alibaba Cloud Documentation Center

The catalog pg_operator stores information about operators.

Column	Type	Description
`oid`	`oid`	Row identifier.
`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 operator (“both”), or `l`= prefix operator (“left”).
`oprcanmerge`	`bool`	This operator supports merge joins.
`oprcanhash`	`bool`	This operator supports hash joins.
`oprleft`	`oid`	Type of the left operand (zero for a prefix operator).
`oprright`	`oid`	Type of the right operand.
`oprresult`	`oid`	Type of the result (zero for a not-yet-defined“shell”operator).
`oprcom`	`oid`	Commutator of this operator (zero if none).
`oprnegate`	`oid`	Negator of this operator (zero if none).
`oprcode`	`regproc`	Function that implements this operator (zero for a not-yet-defined“shell”operator).
`oprrest`	`regproc`	Restriction selectivity estimation function for this operator (zero if none).
`oprjoin`	`regproc`	Join selectivity estimation function for this operator (zero if none).