pg_operator — PostgreSQL system catalog

The PostgreSQL pg_operator system catalog: full column reference (names, types, descriptions), catalog relationships and version support.

The Sev-1 Admin
The Sev-1 Admin  ·  2 min read

Summary

The catalog pg_operator stores information about operators. See createoperator and xoper for more information.

(Description quoted from the official PostgreSQL documentation.)

Columns

The pg_operator system catalog exposes the following columns (names, types and descriptions are taken verbatim from the PostgreSQL documentation):

  • 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 operator (“both”), or l = prefix operator (“left”)
  • 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 (zero for a prefix operator)
  • oprright oid references pg_type.oid
    Type of the right operand
  • oprresult oid references pg_type.oid
    Type of the result (zero for a not-yet-defined “shell” operator)
  • oprcom oid references pg_operator.oid
    Commutator of this operator (zero if none)
  • oprnegate oid references pg_operator.oid
    Negator of this operator (zero if none)
  • oprcode regproc references pg_proc.oid
    Function that implements this operator (zero for a not-yet-defined “shell” operator)
  • oprrest regproc references pg_proc.oid
    Restriction selectivity estimation function for this operator (zero if none)
  • oprjoin regproc references pg_proc.oid
    Join selectivity estimation function for this operator (zero if none)

Related catalogs

This object references the following other system catalogs:

Version applicability

Present in PostgreSQL 17, 18, 19 (verified against each release’s documentation). This is a long-standing system object that also exists in earlier PostgreSQL releases.

Related & references

Reference: PostgreSQL documentation — pg_operator.