Catalogs: pg_operator

The catalog pg_operator stores information about operators. See CREATE OPERATOR and Section 36.12 for more information.

Table 50-34. pg_operator Columns

Name	Type	References	Description
`oid`	`oid`		Row identifier (hidden attribute; must be explicitly selected)
`oprname`	`name`		Name of the operator
`oprnamespace`	`oid`	`pg_namespace.oid`	The 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`	`bool`		This operator supports merge joins
`oprcanhash`	`bool`		This 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

Unused column contain zeroes. For example, oprleft is zero for a prefix operator.

Prev		Next
`pg_opclass`	Up	`pg_opfamily`

Links:

doc_PostgreSQL

2016-10-12 11:32:34

Comments