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 |