1
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
8
CONTENT="Modular DocBook HTML Stylesheet Version 1.79"><LINK
10
HREF="mailto:pgsql-docs@postgresql.org"><LINK
12
TITLE="PostgreSQL 9.1beta1 Documentation"
13
HREF="index.html"><LINK
15
TITLE="System Catalogs"
16
HREF="catalogs.html"><LINK
18
TITLE="pg_foreign_table"
19
HREF="catalog-pg-foreign-table.html"><LINK
22
HREF="catalog-pg-inherits.html"><LINK
25
HREF="stylesheet.css"><META
26
HTTP-EQUIV="Content-Type"
27
CONTENT="text/html; charset=ISO-8859-1"><META
29
CONTENT="2011-04-27T21:20:33"></HEAD
35
SUMMARY="Header navigation table"
47
>PostgreSQL 9.1beta1 Documentation</A
56
TITLE="pg_foreign_table"
57
HREF="catalog-pg-foreign-table.html"
66
TITLE="System Catalogs"
74
>Chapter 45. System Catalogs</TD
80
TITLE="System Catalogs"
90
HREF="catalog-pg-inherits.html"
104
NAME="CATALOG-PG-INDEX"
114
> contains part of the information
115
about indexes. The rest is mostly in
136
><COL><COL><COL><COL><THEAD
164
HREF="catalog-pg-class.html"
175
> entry for this index</TD
192
HREF="catalog-pg-class.html"
203
> entry for the table this index is for</TD
219
>The number of columns in the index (duplicates
222
>pg_class.relnatts</TT
239
>If true, this is a unique index</TD
255
>If true, this index represents the primary key of the table
259
> should always be true when this is true)</TD
275
>If true, this index supports an exclusion constraint</TD
291
>If true, the uniqueness check is enforced immediately on
312
>If true, the table was last clustered on this index</TD
328
> If true, the index is currently valid for queries. False means the
329
index is possibly incomplete: it must still be modified by
336
> operations, but it cannot safely
337
be used for queries. If it is unique, the uniqueness property is not
355
> If true, queries must not use the index until the <TT
362
> row is below their <TT
366
event horizon, because the table may contain broken HOT chains with
367
incompatible rows that they can see
384
> If true, the index is currently ready for inserts. False means the
385
index must be ignored by <TT
410
HREF="catalog-pg-attribute.html"
418
> This is an array of <TT
422
indicate which table columns this index indexes. For example a value
426
> would mean that the first and the third table
427
columns make up the index key. A zero in this array indicates that the
428
corresponding index attribute is an expression over the table columns,
429
rather than a simple column reference.
447
HREF="catalog-pg-collation.html"
455
> For each column in the index key, this contains the OID of the
456
collation to use for the index.
474
HREF="catalog-pg-opclass.html"
482
> For each column in the index key, this contains the OID of
483
the operator class to use. See
485
HREF="catalog-pg-opclass.html"
507
> This is an array of <TT
511
store per-column flag bits. The meaning of the bits is defined by
512
the index's access method.
529
> Expression trees (in <CODE
531
>nodeToString()</CODE
533
representation) for index attributes that are not simple column
534
references. This is a list with one element for each zero
538
>. Null if all index attributes
539
are simple references.
556
> Expression tree (in <CODE
558
>nodeToString()</CODE
560
representation) for partial index predicate. Null if not a
573
SUMMARY="Footer navigation table"
584
HREF="catalog-pg-foreign-table.html"
602
HREF="catalog-pg-inherits.html"
614
>pg_foreign_table</TT
b'\\ No newline at end of file'