Movatterモバイル変換


[0]ホーム

URL:



Facebook
Postgres Pro
Facebook
Downloads
50.34. pg_operator
Prev UpChapter 50. System CatalogsHome Next

50.34. pg_operator

The catalogpg_operator stores information about operators. SeeCREATE OPERATOR andSection 36.14 for more information.

Table 50.34. pg_operator Columns

Column Type

Description

oidoid

Row identifier

oprnamename

Name of the operator

oprnamespaceoid (referencespg_namespace.oid)

The OID of the namespace that contains this operator

oprowneroid (referencespg_authid.oid)

Owner of the operator

oprkindchar

b = infix (both),l = prefix (left),r = postfix (right)

oprcanmergebool

This operator supports merge joins

oprcanhashbool

This operator supports hash joins

oprleftoid (referencespg_type.oid)

Type of the left operand

oprrightoid (referencespg_type.oid)

Type of the right operand

oprresultoid (referencespg_type.oid)

Type of the result

oprcomoid (referencespg_operator.oid)

Commutator of this operator, if any

oprnegateoid (referencespg_operator.oid)

Negator of this operator, if any

oprcoderegproc (referencespg_proc.oid)

Function that implements this operator

oprrestregproc (referencespg_proc.oid)

Restriction selectivity estimation function for this operator

oprjoinregproc (referencespg_proc.oid)

Join selectivity estimation function for this operator


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


Prev Up Next
50.33. pg_opclass Home 50.35. pg_opfamily
pdfepub
Go to Postgres Pro Standard 13
By continuing to browse this website, you agree to the use of cookies. Go toPrivacy Policy.

[8]ページ先頭

©2009-2025 Movatter.jp