PostgreSQL 12 Documentation · 51.34. pg

Documentation → PostgreSQL 12

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

Development versions: 19 / 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

Historical version. PostgreSQL 12 reached end of support in November 2024. See the current version for supported releases.

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`

Read the upstream documentation. For corrections, first check the current version.