Redrock Postgres Search Chinese
Version: 9.3 / 9.4 / 9.5 / 9.6 / 10 / 11 / 12 / 13 / 14 / 15 / 16

48.33. pg_operator

The catalog pg_operator stores information about operators. See CREATE OPERATOR and Section 35.12 for more information.

Table 48-33. pg_operator Columns

NameTypeReferencesDescription
oidoid Row identifier (hidden attribute; must be explicitly selected)
oprnamename Name of the operator
oprnamespaceoidpg_namespace.oid The OID of the namespace that contains this operator
oprowneroidpg_authid.oidOwner of the operator
oprkindchar  b = infix ("both"), l = prefix ("left"), r = postfix ("right")
oprcanmergebool This operator supports merge joins
oprcanhashbool This operator supports hash joins
oprleftoidpg_type.oidType of the left operand
oprrightoidpg_type.oidType of the right operand
oprresultoidpg_type.oidType of the result
oprcomoidpg_operator.oidCommutator of this operator, if any
oprnegateoidpg_operator.oidNegator of this operator, if any
oprcoderegprocpg_proc.oidFunction that implements this operator
oprrestregprocpg_proc.oidRestriction selectivity estimation function for this operator
oprjoinregprocpg_proc.oidJoin selectivity estimation function for this operator

Unused column contain zeroes. For example, oprleft is zero for a prefix operator.