Help Center > > Developer Guide> System Catalogs and System Views> System Catalogs> PG_OPERATOR

PG_OPERATOR

Updated at: Jul 15, 2020 GMT+08:00

PG_OPERATOR records information about operators.

Table 1 PG_OPERATOR columns

Name

Type

Reference

Description

oid

oid

-

Column identifier (hidden attribute; must be explicitly selected)

oprname

name

-

Name of the operator

oprnamespace

oid

PG_NAMESPACE.oid

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

Boolean

-

This operator supports merge joins.

oprcanhash

Boolean

-

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

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?







Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel