PostgreSQL: Documentation: 15: 53.34. pg

Documentation → PostgreSQL 15

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

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 `pg_type`.`oid`) Type of the result (zero for a not-yet-defined “shell” operator)
`oprcom` `oid` (references `pg_operator`.`oid`) Commutator of this operator (zero if none)
`oprnegate` `oid` (references `pg_operator`.`oid`) Negator of this operator (zero if none)
`oprcode` `regproc` (references `pg_proc`.`oid`) Function that implements this operator (zero for a not-yet-defined “shell” operator)
`oprrest` `regproc` (references `pg_proc`.`oid`) Restriction selectivity estimation function for this operator (zero if none)
`oprjoin` `regproc` (references `pg_proc`.`oid`) Join selectivity estimation function for this operator (zero if none)

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 pg_type.oid)

Type of the result (zero for a not-yet-defined “shell” operator)

oprcom oid (references pg_operator.oid)

Commutator of this operator (zero if none)

oprnegate oid (references pg_operator.oid)

Negator of this operator (zero if none)

oprcode regproc (references pg_proc.oid)

Function that implements this operator (zero for a not-yet-defined “shell” operator)

oprrest regproc (references pg_proc.oid)

Restriction selectivity estimation function for this operator (zero if none)

oprjoin regproc (references pg_proc.oid)

Join selectivity estimation function for this operator (zero if none)

Prev	Up	Next
53.33. `pg_opclass`	Home	53.35. `pg_opfamily`

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.

53.34. pg_operator

Submit correction

53.34. `pg_operator`