51.34. pg_operator

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

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 (“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.

Prev | Up | Next
51.33. `pg_opclass` | Home | 51.35. `pg_opfamily`