PG_OPERATOR

oid

oid

-

Row identifier (hidden attribute, which must be specified)

oprname

name

-

Name of an operator

oprnamespace

oid

OID in PG_NAMESPACE

OID of the namespace that contains the operator

oprowner

oid

OID in PG_AUTHID

Owner of the operator

oprkind

"char"

-

• b: infix ("both")
• l: prefix ("left")
• r: postfix ("right")

oprcanmerge

boolean

-

Whether the operator supports merge joins

• t (true): yes
• f (false): no

oprcanhash

boolean

-

Whether the operator supports hash joins

• t (true): yes
• f (false): no

oprleft

oid

OID in PG_TYPE

Type of the left operand

oprright

oid

OID in PG_TYPE

Type of the right operand

oprresult

oid

OID in PG_TYPE

Type of the result

oprcom

oid

OID in PG_OPERATOR

Commutator of this operator, if any

oprnegate

oid

OID in PG_OPERATOR

Negator of this operator, if any

oprcode

regproc

PG_PROC.proname

Function that implements the operator

oprrest

regproc

PG_PROC.proname

Restriction selectivity estimation function for the operator

oprjoin

regproc

PG_PROC.proname

Join selectivity estimation function for the operator