14th September 2023: PostgreSQL 16 Released!
Supported Versions: Current (16) / 15 / 14 / 13 / 12 / 11
Development Versions: 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

51.34. pg_operator

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

Table 51.34. pg_operator Columns

Column Type


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 (both), l = prefix (left), r = postfix (right)

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

oprright oid (references pg_type.oid)

Type of the right operand

oprresult oid (references pg_type.oid)

Type of the result

oprcom oid (references pg_operator.oid)

Commutator of this operator, if any

oprnegate oid (references pg_operator.oid)

Negator of this operator, if any

oprcode regproc (references pg_proc.oid)

Function that implements this operator

oprrest regproc (references pg_proc.oid)

Restriction selectivity estimation function for this operator

oprjoin regproc (references 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.