PG_OPERATOR
PG_OPERATOR records information about operators.
Table 1 PG_OPERATOR columns
Name | Type | Reference | Description |
---|
oid | oid | - | Row identifier (hidden attribute, which must be specified) |
oprname | name | - | Name of an operator |
oprnamespace | oid | OID in PG_NAMESPACE | OID of the namespace that contains the operator |
oprowner | oid | OID in PG_AUTHID | Owner of the operator |
oprkind | "char" | - | - b: infix ("both")
- l: prefix ("left")
- r: postfix ("right")
|
oprcanmerge | boolean | - | Whether the operator supports merge joins - t (true): yes
- f (false): no
|
oprcanhash | boolean | - | Whether the operator supports hash joins - t (true): yes
- f (false): no
|
oprleft | oid | OID in PG_TYPE | Type of the left operand |
oprright | oid | OID in PG_TYPE | Type of the right operand |
oprresult | oid | OID in PG_TYPE | Type of the result |
oprcom | oid | OID in PG_OPERATOR | Commutator of this operator, if any |
oprnegate | oid | OID in PG_OPERATOR | Negator of this operator, if any |
oprcode | regproc | PG_PROC.proname | Function that implements the operator |
oprrest | regproc | PG_PROC.proname | Restriction selectivity estimation function for the operator |
oprjoin | regproc | PG_PROC.proname | Join selectivity estimation function for the operator |
openGauss 2025-04-30 22:43:40