PostgreSQL

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