Movatterモバイル変換


[0]ホーム

URL:



Facebook
Postgres Pro
Facebook
Downloads
52.11. pg_indexes
Prev UpChapter 52. System ViewsHome Next

52.11. pg_indexes#

The viewpg_indexes provides access to useful information about each index in the database.

Table 52.11. pg_indexes Columns

Column Type

Description

schemanamename (referencespg_namespace.nspname)

Name of schema containing table and index

tablenamename (referencespg_class.relname)

Name of table the index is for

indexnamename (referencespg_class.relname)

Name of index

tablespacename (referencespg_tablespace.spcname)

Name of tablespace containing index (null if default for database)

indexdeftext

Index definition (a reconstructedCREATE INDEX command)



Prev Up Next
52.10. pg_ident_file_mappings Home 52.12. pg_locks
pdfepub
Go to Postgres Pro Standard 17
By continuing to browse this website, you agree to the use of cookies. Go toPrivacy Policy.

[8]ページ先頭

©2009-2025 Movatter.jp