PostgreSQL

oid oid

Row identifier

oprname name

Name of the operator

oprnamespace oid (references pg_namespace.oid)

The OID of the namespace that contains this operator

oprowner oid (references 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 (references pg_type.oid)

Type of the left operand

oprright oid (references pg_type.oid)

Type of the right operand

oprresult oid (references pg_type.oid)

Type of the result

oprcom oid (references pg_operator.oid)

Commutator of this operator, if any

oprnegate oid (references pg_operator.oid)

Negator of this operator, if any

oprcode regproc (references pg_proc.oid)

Function that implements this operator

oprrest regproc (references pg_proc.oid)

Restriction selectivity estimation function for this operator

oprjoin regproc (references pg_proc.oid)

Join selectivity estimation function for this operator