PostgreSQL

PostgreSQL Elephant Logo

52.34. pg_operator

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

Table 52.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 (“[.quote]#both), or l = prefix operator ([.quote]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 “[.quote]#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 “[.quote]#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

52.33. pg_opclass

Home

52.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.

Copyright © 1996-2023 The PostgreSQL Global Development Group