PostgreSQL

PostgreSQL Elephant Logo

52.34. pg_operator

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

Table 52.34. pg_operator Columns

Name Type References Description

oid

oid

Row identifier (hidden attribute; must be explicitly selected)

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 (“[.quote]#both), l = prefix ([.quote]left), r = postfix ([.quote]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

52.33. pg_opclass

Home

52.35. pg_opfamily

Copyright © 1996-2023 The PostgreSQL Global Development Group