• Data Warehouse Service

dws
  1. Help Center
  2. Data Warehouse Service
  3. Developer Guide
  4. Systems Tables and Views
  5. PG_OPERATOR

PG_OPERATOR

PG_OPERATOR stores 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