Free Webmaster Tools and Resources

W3-Tools.com

Search Engine Optimization Domain Names Webmasters Web design

Webmaster Forum Webmaster News Links Directory

Search Engine Spider Simulator Keyword Analyser Tool Keywords Generator

Domain Tools

Domain Name Checker Whois Domain Lookup Domain Typo Generator

Web Utilities

HTTP Header Viewer Link Extractor Mime Types List

HTML Tools

Websafe Color Tool HTML Entity Chart

Documentation

PHP Manual PEAR Manual Smarty Manual PHP-GTK Manual Apache Manual MySQL Manual PostgreSQL Manual

PostgreSQL Manual

This manual is provided as a courtesy. It is not an official source. Please check postgresql.org for updated information.

PostgreSQL Manual

PostgreSQL 8.1.3 Documentation
Prev	Fast Backward	Chapter 42. System Catalogs	Fast Forward	Next

42.36. `pg_indexes`

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

Table 42-36. pg_indexes Columns

Name	Type	References	Description
`schemaname`	`name`	`pg_namespace.nspname`	name of schema containing table and index
`tablename`	`name`	`pg_class.relname`	name of table the index is for
`indexname`	`name`	`pg_class.relname`	name of index
`tablespace`	`name`	`pg_tablespace.spcname`	name of tablespace containing index (NULL if default for database)
`indexdef`	`text`		index definition (a reconstructed creation command)

Prev	Home	Next
`pg_group`	Up	`pg_locks`

Newsletter

Join to our newsletter and receive news and updates about our site.
Your name:
E-mail address:
Action:

Hosted by

Search

			Links

Copyright © 2006. by w3-tools.com. All rights reserved