pg_operator

The pg_operator system catalog table stores information about operators, both built-in and those defined by CREATE OPERATOR. Unused column contain zeroes. For example, oprleft is zero for a prefix operator.

columntypereferencesdescription
oprnamename Name of the operator.
oprnamespaceoidpg_namespace.oidThe OID of the namespace that contains this operator.
oprowneroidpg_authid.oidOwner of the operator.
oprkindchar b = infix (both), l = prefix (left), r = postfix (right)
oprcanhashboolean 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.
oprnegate pg_operator.oidNegator of this operator, if any.
oprlsortopoidpg_operator.oidIf this operator supports merge joins, the operator that sorts the type of the left-hand operand (L<L).
oprrsortopoidpg_operator.oidIf this operator supports merge joins, the operator that sorts the type of the right-hand operand (R<R).
oprltcmpopoidpg_operator.oidIf this operator supports merge joins, the less-than operator that compares the left and right operand types (L<R).
oprgtcmpopoidpg_operator.oidIf this operator supports merge joins, the greater-than operator that compares the left and right operand types (L>R).
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.

Parent topic: System Catalogs Definitions