Supported Versions: Current (15) / 14 / 13 / 12 / 11
Development Versions: 16 / devel
Unsupported versions: 10 / 9.6 / 9.5 / 9.4 / 9.3 / 9.2 / 9.1 / 9.0 / 8.4 / 8.3 / 8.2 / 8.1 / 8.0 / 7.4 / 7.3 / 7.2 / 7.1

52.34. pg_operator

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

Table 52.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 pg_namespace.oid The OID of the namespace that contains this operator
oprowner oid pg_authid.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 pg_type.oid Type of the left operand
oprright oid pg_type.oid Type of the right operand
oprresult oid pg_type.oid Type of the result
oprcom oid pg_operator.oid Commutator of this operator, if any
oprnegate oid pg_operator.oid Negator of this operator, if any
oprcode regproc pg_proc.oid Function that implements this operator
oprrest regproc pg_proc.oid Restriction selectivity estimation function for this operator
oprjoin regproc pg_proc.oid Join selectivity estimation function for this operator

Unused columns contain zeroes. For example, oprleft is zero for a prefix operator.

Submit correction

If you see anything in the documentation that is not correct, does not match your experience with the particular feature or requires further clarification, please use this form to report a documentation issue.