September 26, 2024: PostgreSQL 17 Released!
Supported Versions: Current (17) / 16 / 15 / 14 / 13 / 12
Development Versions: devel
Unsupported versions: 11 / 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
This documentation is for an unsupported version of PostgreSQL.
You may want to view the same page for the current version, or one of the other supported versions listed above instead.

44.27. pg_operator

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

Table 44-27. pg_operator Columns

Name Type References Description
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 column contain zeroes. For example, oprleft is zero for a prefix operator.