## 52.34. `pg_operator`[]() The catalog `pg_operator` stores information about operators. See [CREATE OPERATOR](sql-createoperator.html) and [Section 38.14](xoper.html) for more information.**Table 52.34. `pg_operator` Columns**| Column Type<br/><br/> Description ||-----------------------------------------------------------------------------------------------------------------------------------------------------------------------|| `oid``oid`<br/><br/> Row identifier || `oprname``name`<br/><br/> Name of the operator || `oprnamespace``oid` (references [`pg_namespace`](catalog-pg-namespace.html).`oid`)<br/><br/> The OID of the namespace that contains this operator || `oprowner``oid` (references [`pg_authid`](catalog-pg-authid.html).`oid`)<br/><br/> Owner of the operator || `oprkind``char`<br/><br/>`b` = infix operator (“both”), or `l` = prefix operator (“left”) || `oprcanmerge``bool`<br/><br/> This operator supports merge joins || `oprcanhash``bool`<br/><br/> This operator supports hash joins || `oprleft``oid` (references [`pg_type`](catalog-pg-type.html).`oid`)<br/><br/> Type of the left operand (zero for a prefix operator) || `oprright``oid` (references [`pg_type`](catalog-pg-type.html).`oid`)<br/><br/> Type of the right operand || `oprresult``oid` (references [`pg_type`](catalog-pg-type.html).`oid`)<br/><br/> Type of the result (zero for a not-yet-defined “shell” operator) || `oprcom``oid` (references [`pg_operator`](catalog-pg-operator.html).`oid`)<br/><br/> Commutator of this operator (zero if none) || `oprnegate``oid` (references [`pg_operator`](catalog-pg-operator.html).`oid`)<br/><br/> Negator of this operator (zero if none) ||`oprcode``regproc` (references [`pg_proc`](catalog-pg-proc.html).`oid`)<br/><br/> Function that implements this operator (zero for a not-yet-defined “shell” operator)|| `oprrest``regproc` (references [`pg_proc`](catalog-pg-proc.html).`oid`)<br/><br/> Restriction selectivity estimation function for this operator (zero if none) || `oprjoin``regproc` (references [`pg_proc`](catalog-pg-proc.html).`oid`)<br/><br/> Join selectivity estimation function for this operator (zero if none) |
