Lu, Huayi a24ca60074 DWS DEVELOPER 811 version

Reviewed-by: Hasko, Vladimir <vladimir.hasko@t-systems.com>
Co-authored-by: Lu, Huayi <luhuayi@huawei.com>
Co-committed-by: Lu, Huayi <luhuayi@huawei.com>

2023-01-19 13:37:49 +00:00

14 KiB

Raw Permalink Blame History

PG_OPERATOR

PG_OPERATOR records information about operators.

**Table 1** PG_OPERATOR columns
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"	-	b: infix ("both") l: prefix ("left") r: postfix ("right")
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

Parent topic: System Catalogs

14 KiB Raw Permalink Blame History

PG_OPERATOR

14 KiB

Raw Permalink Blame History