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