PostgreSQL: Documentation: 15: 53.34. pg

Documentation → PostgreSQL 15

Supported Versions: Current (18) / 17 / 16 / 15 / 14

Development Versions: devel

Unsupported versions: 13 / 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

53.34. `pg_operator`
Prev	Up	Chapter 53. System Catalogs	Home	Next

53.34. `pg_operator`

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

Table 53.34. pg_operator Columns

Column Type Description
`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 operator (“both”), or `l` = prefix operator (“left”)
`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 (zero for a prefix operator)
`oprright` `oid` (references `pg_type`.`oid`) Type of the right operand
`oprresult` `oid` (references

Column Type

Description

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 operator (“both”), or l = prefix operator (“left”)

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 (zero for a prefix operator)

oprright oid (references pg_type.oid)

Type of the right operand

oprresult oid (references