PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

SYSTEM CATALOGS / SYSTEM CATALOGS

pg_operator

Read PG 18 manual ↗

The catalog pg_operator stores information about operators.

Kind: System catalogs
Columns in this snapshot: 15
Definition source: English manual

Columns 15

Column	Type	Description / reference
`oid`	`oid`	Row identifier
`oprname`	`name`	Name of the operator
`oprnamespace`	`oid`	The OID of the namespace that contains this operator pg_namespace.oid
`oprowner`	`oid`	Owner of the operator pg_authid.oid
`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`	Type of the left operand (zero for a prefix operator) pg_type.oid
`oprright`	`oid`	Type of the right operand pg_type.oid
`oprresult`	`oid`	Type of the result (zero for a not-yet-defined “shell” operator) pg_type.oid
`oprcom`	`oid`	Commutator of this operator (zero if none)
`oprnegate`	`oid`	Negator of this operator (zero if none)
`oprcode`	`regproc`	Function that implements this operator (zero for a not-yet-defined “shell” operator) pg_proc.oid
`oprrest`	`regproc`	Restriction selectivity estimation function for this operator (zero if none) pg_proc.oid
`oprjoin`	`regproc`	Join selectivity estimation function for this operator (zero if none) pg_proc.oid

Column history across versions

Column	9.0	9.1	9.2	9.3	9.4	9.5	9.6	10	11	12	13	14	15	16	17	18	19	20
`oid`	·	·	·	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`oprname`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`oprnamespace`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`oprowner`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`oprkind`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`oprcanmerge`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`oprcanhash`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`oprleft`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`oprright`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`oprresult`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`oprcom`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`oprnegate`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`oprcode`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`oprrest`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`oprjoin`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●

Version history 7

Definition snapshot: english-manuals:9b973cdf37ad2f1cba6c68a1c49… · English manual source