November 21, 2024: PostgreSQL 17.2, 16.6, 15.10, 14.15, 13.18, and 12.22 Released!
Supported Versions: Current (17) / 16 / 15 / 14 / 13
Development Versions: devel
Unsupported versions: 12 / 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.
51.34. pg_operator
Prev  Up Chapter 51. System Catalogs Home  Next

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

Name Type References Description
oid oid   Row identifier
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.

Prev  Up  Next
51.33. pg_opclass  Home  51.35. pg_opfamily