The catalog pg_operator stores information about operators. See CREATE OPERATOR and Section 36.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 (“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)

|