3
3
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
4
<title>41.32.�pg_indexes</title>
4
<title>42.36.�pg_indexes</title>
5
5
<link rel="stylesheet" href="stylesheet.css" type="text/css">
6
6
<link rev="made" href="pgsql-docs@postgresql.org">
7
<meta name="generator" content="DocBook XSL Stylesheets V1.64.1">
8
<link rel="home" href="index.html" title="PostgreSQL 8.0.0beta5 Documentation">
9
<link rel="up" href="catalogs.html" title="Chapter�41.�System Catalogs">
10
<link rel="previous" href="views-overview.html" title="41.31.�System Views">
11
<link rel="next" href="view-pg-locks.html" title="41.33.�pg_locks">
7
<meta name="generator" content="DocBook XSL Stylesheets V1.70.0">
8
<link rel="start" href="index.html" title="PostgreSQL 8.1.4 Documentation">
9
<link rel="up" href="catalogs.html" title="Chapter�42.�System Catalogs">
10
<link rel="prev" href="view-pg-group.html" title="42.35.�pg_group">
11
<link rel="next" href="view-pg-locks.html" title="42.37.�pg_locks">
12
<link rel="copyright" href="ln-legalnotice.html" title="Legal Notice">
13
14
<body bgcolor="white" text="black" link="#0000FF" vlink="#840084" alink="#0000FF"><div class="sect1" lang="en">
14
<div class="titlepage">
15
<div><div><h2 class="title" style="clear: both">
16
<a name="view-pg-indexes"></a>41.32.�<tt class="structname">pg_indexes</tt></h2></div></div>
19
<a name="id2729766"></a><p> The view <tt class="structname">pg_indexes</tt> provides access to
15
<div class="titlepage"><div><div><h2 class="title" style="clear: both">
16
<a name="view-pg-indexes"></a>42.36.�<code class="structname">pg_indexes</code></h2></div></div></div>
17
<a name="id831163"></a><p> The view <code class="structname">pg_indexes</code> provides access to
20
18
useful information about each index in the database.
22
20
<div class="table">
23
<a name="id2729783"></a><p class="title"><b>Table�41.32.�<tt class="structname">pg_indexes</tt> Columns</b></p>
24
<table summary="pg_indexes Columns" border="1">
21
<a name="id831181"></a><p class="title"><b>Table�42.36.�<code class="structname">pg_indexes</code> Columns</b></p>
22
<div class="table-contents"><table summary="pg_indexes Columns" border="1">
39
<td><tt class="structfield">schemaname</tt></td>
40
<td><tt class="type">name</tt></td>
41
<td><tt class="literal"><a href="catalog-pg-namespace.html" title="41.21.�pg_namespace"><tt class="structname">pg_namespace</tt></a>.nspname</tt></td>
37
<td><code class="structfield">schemaname</code></td>
38
<td><code class="type">name</code></td>
39
<td><code class="literal"><a href="catalog-pg-namespace.html" title="42.23.�pg_namespace"><code class="structname">pg_namespace</code></a>.nspname</code></td>
42
40
<td>name of schema containing table and index</td>
45
<td><tt class="structfield">tablename</tt></td>
46
<td><tt class="type">name</tt></td>
47
<td><tt class="literal"><a href="catalog-pg-class.html" title="41.9.�pg_class"><tt class="structname">pg_class</tt></a>.relname</tt></td>
43
<td><code class="structfield">tablename</code></td>
44
<td><code class="type">name</code></td>
45
<td><code class="literal"><a href="catalog-pg-class.html" title="42.12.�pg_class"><code class="structname">pg_class</code></a>.relname</code></td>
48
46
<td>name of table the index is for</td>
51
<td><tt class="structfield">indexname</tt></td>
52
<td><tt class="type">name</tt></td>
53
<td><tt class="literal"><a href="catalog-pg-class.html" title="41.9.�pg_class"><tt class="structname">pg_class</tt></a>.relname</tt></td>
49
<td><code class="structfield">indexname</code></td>
50
<td><code class="type">name</code></td>
51
<td><code class="literal"><a href="catalog-pg-class.html" title="42.12.�pg_class"><code class="structname">pg_class</code></a>.relname</code></td>
54
52
<td>name of index</td>
57
<td><tt class="structfield">tablespace</tt></td>
58
<td><tt class="type">name</tt></td>
59
<td><tt class="literal"><a href="catalog-pg-tablespace.html" title="41.28.�pg_tablespace"><tt class="structname">pg_tablespace</tt></a>.spcname</tt></td>
55
<td><code class="structfield">tablespace</code></td>
56
<td><code class="type">name</code></td>
57
<td><code class="literal"><a href="catalog-pg-tablespace.html" title="42.31.�pg_tablespace"><code class="structname">pg_tablespace</code></a>.spcname</code></td>
60
58
<td>name of tablespace containing index (NULL if default for database)</td>
63
<td><tt class="structfield">indexdef</tt></td>
64
<td><tt class="type">text</tt></td>
61
<td><code class="structfield">indexdef</code></td>
62
<td><code class="type">text</code></td>
66
64
<td>index definition (a reconstructed creation command)</td>
69
<br class="table-break">