From 5e45211a64149b3c659b90ff2de6fa982a5a93ed Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sat, 4 May 2024 14:17:33 +0200 Subject: Adding upstream version 15.5. Signed-off-by: Daniel Baumann --- doc/src/sgml/html/view-pg-indexes.html | 40 ++++++++++++++++++++++++++++++++++ 1 file changed, 40 insertions(+) create mode 100644 doc/src/sgml/html/view-pg-indexes.html (limited to 'doc/src/sgml/html/view-pg-indexes.html') diff --git a/doc/src/sgml/html/view-pg-indexes.html b/doc/src/sgml/html/view-pg-indexes.html new file mode 100644 index 0000000..8f8cb53 --- /dev/null +++ b/doc/src/sgml/html/view-pg-indexes.html @@ -0,0 +1,40 @@ + +54.11. pg_indexes
54.11. pg_indexes
Prev UpChapter 54. System ViewsHome Next

54.11. pg_indexes

+ The view pg_indexes provides access to + useful information about each index in the database. +

Table 54.11. pg_indexes Columns

+ Column Type +

+

+ Description +

+ schemaname name + (references pg_namespace.nspname) +

+

+ Name of schema containing table and index +

+ tablename name + (references pg_class.relname) +

+

+ Name of table the index is for +

+ indexname name + (references pg_class.relname) +

+

+ Name of index +

+ tablespace name + (references pg_tablespace.spcname) +

+

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

+ indexdef text +

+

+ Index definition (a reconstructed CREATE INDEX + command) +


Prev Up Next
54.10. pg_ident_file_mappings Home 54.12. pg_locks
\ No newline at end of file -- cgit v1.2.3