PG_OPERATOR
PG_OPERATOR records information about operators.
| Name | Type | Reference | Description |
|---|---|---|---|
| OID | OID | N/A | Row identifier (hidden attribute; displayed only when explicitly selected) |
| oprname | Name | N/A | Name of the operator |
| oprnamespace | OID | PG_NAMESPACE.oid | OID of the namespace that contains this operator |
| oprowner | OID | PG_AUTHID.oid | Owner of the operator |
| oprkind | Char | N/A |
|
| oprcanmerge | boolean | N/A | Whether the operator supports merge joins |
| oprcanhash | boolean | N/A | Whether the operator supports hash joins |
| oprleft | OID | PG_TYPE.oid | Type of the left operand |
| oprright | OID | PG_TYPE.oid | Type of the right operand |
| oprresult | OID | PG_TYPE.oid | Type of the result |
| oprcom | OID | PG_OPERATOR.oid | Commutator of this operator, if any |
| oprnegate | OID | PG_OPERATOR.oid | Negator of this operator, if any |
| oprcode | regproc | PG_PROC.oid | Function that implements this operator |
| oprrest | regproc | PG_PROC.oid | Restriction selectivity estimation function for this operator |
| oprjoin | regproc | PG_PROC.oid | Join selectivity estimation function for this operator |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.
