PG_OPERATOR
PG_OPERATOR records information about operators.
| Name | Type | Reference | Description |
|---|---|---|---|
| oid | oid | - | Row identifier (hidden attribute; must be explicitly selected) |
| oprname | name | - | 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" | - |
|
| oprcanmerge | Boolean | - | Whether the operator supports merge joins |
| oprcanhash | Boolean | - | 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 |
Last Article: PG_OPCLASS
Next Article: PG_OPFAMILY
Did this article solve your problem?
Thank you for your score！Your feedback would help us improve the website.