Sophie: postgresql8.2-docs-8.2.14-1mdv2010.0 i586

postgresql8.2-docs-8.2.14-1mdv2010.0.i586.rpm

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<HTML
><HEAD
><TITLE
>Overview</TITLE
><META
NAME="GENERATOR"
CONTENT="Modular DocBook HTML Stylesheet Version 1.79"><LINK
REV="MADE"
HREF="mailto:pgsql-docs@postgresql.org"><LINK
REL="HOME"
TITLE="PostgreSQL 8.2.14 Documentation"
HREF="index.html"><LINK
REL="UP"
TITLE="System Catalogs"
HREF="catalogs.html"><LINK
REL="PREVIOUS"
TITLE="System Catalogs"
HREF="catalogs.html"><LINK
REL="NEXT"
TITLE="pg_aggregate"
HREF="catalog-pg-aggregate.html"><LINK
REL="STYLESHEET"
TYPE="text/css"
HREF="stylesheet.css"><META
HTTP-EQUIV="Content-Type"
CONTENT="text/html; charset=ISO-8859-1"><META
NAME="creation"
CONTENT="2009-09-04T05:25:47"></HEAD
><BODY
CLASS="SECT1"
><DIV
CLASS="NAVHEADER"
><TABLE
SUMMARY="Header navigation table"
WIDTH="100%"
BORDER="0"
CELLPADDING="0"
CELLSPACING="0"
><TR
><TH
COLSPAN="5"
ALIGN="center"
VALIGN="bottom"
>PostgreSQL 8.2.14 Documentation</TH
></TR
><TR
><TD
WIDTH="10%"
ALIGN="left"
VALIGN="top"
><A
HREF="catalogs.html"
ACCESSKEY="P"
>Prev</A
></TD
><TD
WIDTH="10%"
ALIGN="left"
VALIGN="top"
><A
HREF="catalogs.html"
>Fast Backward</A
></TD
><TD
WIDTH="60%"
ALIGN="center"
VALIGN="bottom"
>Chapter 43. System Catalogs</TD
><TD
WIDTH="10%"
ALIGN="right"
VALIGN="top"
><A
HREF="catalogs.html"
>Fast Forward</A
></TD
><TD
WIDTH="10%"
ALIGN="right"
VALIGN="top"
><A
HREF="catalog-pg-aggregate.html"
ACCESSKEY="N"
>Next</A
></TD
></TR
></TABLE
><HR
ALIGN="LEFT"
WIDTH="100%"></DIV
><DIV
CLASS="SECT1"
><H1
CLASS="SECT1"
><A
NAME="CATALOGS-OVERVIEW"
>43.1. Overview</A
></H1
><P
>   <A
HREF="catalogs-overview.html#CATALOG-TABLE"
>Table 43-1</A
> lists the system catalogs.
   More detailed documentation of each catalog follows below.
  </P
><P
>   Most system catalogs are copied from the template database during
   database creation and are thereafter database-specific. A few
   catalogs are physically shared across all databases in a cluster;
   these are noted in the descriptions of the individual catalogs.
  </P
><DIV
CLASS="TABLE"
><A
NAME="CATALOG-TABLE"
></A
><P
><B
>Table 43-1. System Catalogs</B
></P
><TABLE
BORDER="1"
CLASS="CALSTABLE"
><COL><COL><THEAD
><TR
><TH
>Catalog Name</TH
><TH
>Purpose</TH
></TR
></THEAD
><TBODY
><TR
><TD
><A
HREF="catalog-pg-aggregate.html"
><TT
CLASS="STRUCTNAME"
>pg_aggregate</TT
></A
></TD
><TD
>aggregate functions</TD
></TR
><TR
><TD
><A
HREF="catalog-pg-am.html"
><TT
CLASS="STRUCTNAME"
>pg_am</TT
></A
></TD
><TD
>index access methods</TD
></TR
><TR
><TD
><A
HREF="catalog-pg-amop.html"
><TT
CLASS="STRUCTNAME"
>pg_amop</TT
></A
></TD
><TD
>access method operators</TD
></TR
><TR
><TD
><A
HREF="catalog-pg-amproc.html"
><TT
CLASS="STRUCTNAME"
>pg_amproc</TT
></A
></TD
><TD
>access method support procedures</TD
></TR
><TR
><TD
><A
HREF="catalog-pg-attrdef.html"
><TT
CLASS="STRUCTNAME"
>pg_attrdef</TT
></A
></TD
><TD
>column default values</TD
></TR
><TR
><TD
><A
HREF="catalog-pg-attribute.html"
><TT
CLASS="STRUCTNAME"
>pg_attribute</TT
></A
></TD
><TD
>table columns (<SPAN
CLASS="QUOTE"
>"attributes"</SPAN
>)</TD
></TR
><TR
><TD
><A
HREF="catalog-pg-authid.html"
><TT
CLASS="STRUCTNAME"
>pg_authid</TT
></A
></TD
><TD
>authorization identifiers (roles)</TD
></TR
><TR
><TD
><A
HREF="catalog-pg-auth-members.html"
><TT
CLASS="STRUCTNAME"
>pg_auth_members</TT
></A
></TD
><TD
>authorization identifier membership relationships</TD
></TR
><TR
><TD
><A
HREF="catalog-pg-autovacuum.html"
><TT
CLASS="STRUCTNAME"
>pg_autovacuum</TT
></A
></TD
><TD
>per-relation autovacuum configuration parameters</TD
></TR
><TR
><TD
><A
HREF="catalog-pg-cast.html"
><TT
CLASS="STRUCTNAME"
>pg_cast</TT
></A
></TD
><TD
>casts (data type conversions)</TD
></TR
><TR
><TD
><A
HREF="catalog-pg-class.html"
><TT
CLASS="STRUCTNAME"
>pg_class</TT
></A
></TD
><TD
>tables, indexes, sequences, views (<SPAN
CLASS="QUOTE"
>"relations"</SPAN
>)</TD
></TR
><TR
><TD
><A
HREF="catalog-pg-constraint.html"
><TT
CLASS="STRUCTNAME"
>pg_constraint</TT
></A
></TD
><TD
>check constraints, unique constraints, primary key constraints, foreign key constraints</TD
></TR
><TR
><TD
><A
HREF="catalog-pg-conversion.html"
><TT
CLASS="STRUCTNAME"
>pg_conversion</TT
></A
></TD
><TD
>encoding conversion information</TD
></TR
><TR
><TD
><A
HREF="catalog-pg-database.html"
><TT
CLASS="STRUCTNAME"
>pg_database</TT
></A
></TD
><TD
>databases within this database cluster</TD
></TR
><TR
><TD
><A
HREF="catalog-pg-depend.html"
><TT
CLASS="STRUCTNAME"
>pg_depend</TT
></A
></TD
><TD
>dependencies between database objects</TD
></TR
><TR
><TD
><A
HREF="catalog-pg-description.html"
><TT
CLASS="STRUCTNAME"
>pg_description</TT
></A
></TD
><TD
>descriptions or comments on database objects</TD
></TR
><TR
><TD
><A
HREF="catalog-pg-index.html"
><TT
CLASS="STRUCTNAME"
>pg_index</TT
></A
></TD
><TD
>additional index information</TD
></TR
><TR
><TD
><A
HREF="catalog-pg-inherits.html"
><TT
CLASS="STRUCTNAME"
>pg_inherits</TT
></A
></TD
><TD
>table inheritance hierarchy</TD
></TR
><TR
><TD
><A
HREF="catalog-pg-language.html"
><TT
CLASS="STRUCTNAME"
>pg_language</TT
></A
></TD
><TD
>languages for writing functions</TD
></TR
><TR
><TD
><A
HREF="catalog-pg-largeobject.html"
><TT
CLASS="STRUCTNAME"
>pg_largeobject</TT
></A
></TD
><TD
>large objects</TD
></TR
><TR
><TD
><A
HREF="catalog-pg-listener.html"
><TT
CLASS="STRUCTNAME"
>pg_listener</TT
></A
></TD
><TD
>asynchronous notification support</TD
></TR
><TR
><TD
><A
HREF="catalog-pg-namespace.html"
><TT
CLASS="STRUCTNAME"
>pg_namespace</TT
></A
></TD
><TD
>schemas</TD
></TR
><TR
><TD
><A
HREF="catalog-pg-opclass.html"
><TT
CLASS="STRUCTNAME"
>pg_opclass</TT
></A
></TD
><TD
>index access method operator classes</TD
></TR
><TR
><TD
><A
HREF="catalog-pg-operator.html"
><TT
CLASS="STRUCTNAME"
>pg_operator</TT
></A
></TD
><TD
>operators</TD
></TR
><TR
><TD
><A
HREF="catalog-pg-pltemplate.html"
><TT
CLASS="STRUCTNAME"
>pg_pltemplate</TT
></A
></TD
><TD
>template data for procedural languages</TD
></TR
><TR
><TD
><A
HREF="catalog-pg-proc.html"
><TT
CLASS="STRUCTNAME"
>pg_proc</TT
></A
></TD
><TD
>functions and procedures</TD
></TR
><TR
><TD
><A
HREF="catalog-pg-rewrite.html"
><TT
CLASS="STRUCTNAME"
>pg_rewrite</TT
></A
></TD
><TD
>query rewrite rules</TD
></TR
><TR
><TD
><A
HREF="catalog-pg-shdepend.html"
><TT
CLASS="STRUCTNAME"
>pg_shdepend</TT
></A
></TD
><TD
>dependencies on shared objects</TD
></TR
><TR
><TD
><A
HREF="catalog-pg-shdescription.html"
><TT
CLASS="STRUCTNAME"
>pg_shdescription</TT
></A
></TD
><TD
>comments on shared objects</TD
></TR
><TR
><TD
><A
HREF="catalog-pg-statistic.html"
><TT
CLASS="STRUCTNAME"
>pg_statistic</TT
></A
></TD
><TD
>planner statistics</TD
></TR
><TR
><TD
><A
HREF="catalog-pg-tablespace.html"
><TT
CLASS="STRUCTNAME"
>pg_tablespace</TT
></A
></TD
><TD
>tablespaces within this database cluster</TD
></TR
><TR
><TD
><A
HREF="catalog-pg-trigger.html"
><TT
CLASS="STRUCTNAME"
>pg_trigger</TT
></A
></TD
><TD
>triggers</TD
></TR
><TR
><TD
><A
HREF="catalog-pg-type.html"
><TT
CLASS="STRUCTNAME"
>pg_type</TT
></A
></TD
><TD
>data types</TD
></TR
></TBODY
></TABLE
></DIV
></DIV
><DIV
CLASS="NAVFOOTER"
><HR
ALIGN="LEFT"
WIDTH="100%"><TABLE
SUMMARY="Footer navigation table"
WIDTH="100%"
BORDER="0"
CELLPADDING="0"
CELLSPACING="0"
><TR
><TD
WIDTH="33%"
ALIGN="left"
VALIGN="top"
><A
HREF="catalogs.html"
ACCESSKEY="P"
>Prev</A
></TD
><TD
WIDTH="34%"
ALIGN="center"
VALIGN="top"
><A
HREF="index.html"
ACCESSKEY="H"
>Home</A
></TD
><TD
WIDTH="33%"
ALIGN="right"
VALIGN="top"
><A
HREF="catalog-pg-aggregate.html"
ACCESSKEY="N"
>Next</A
></TD
></TR
><TR
><TD
WIDTH="33%"
ALIGN="left"
VALIGN="top"
>System Catalogs</TD
><TD
WIDTH="34%"
ALIGN="center"
VALIGN="top"
><A
HREF="catalogs.html"
ACCESSKEY="U"
>Up</A
></TD
><TD
WIDTH="33%"
ALIGN="right"
VALIGN="top"
><TT
CLASS="STRUCTNAME"
>pg_aggregate</TT
></TD
></TR
></TABLE
></DIV
></BODY
></HTML
>