Index: catalogs.sgml
===================================================================
RCS file: /projects/cvsroot/pgsql-server/doc/src/sgml/catalogs.sgml,v
retrieving revision 2.62
diff -c -r2.62 catalogs.sgml
*** catalogs.sgml 2002/09/24 21:26:44 2.62
--- catalogs.sgml 2002/10/11 12:05:04
***************
*** 23,28 ****
--- 23,33 ----
creates the database on disk.) There are some exceptions for
especially esoteric operations, such as adding index access methods.
+
+ Most of the system catalogs are copied during database creation from
+ the template database, as such are database specific. Exceptions are
+ mentioned in the description of the individual catalog.
+
System Catalogs
***************
*** 37,43 ****
! pg_aggregate
aggregate functions
--- 42,49 ----
! pg_aggregate aggregate functions
***************
*** 57,178 ****
! pg_attrdef
column default values
! pg_attribute
table columns (attributes
, fields
)
! pg_cast
casts (data type conversions)
! pg_class
tables, indexes, sequences (relations
)
! pg_constraint
check constraints, unique / primary key constraints, foreign key constraints
! pg_conversion
encoding conversion information
! pg_database
databases within this database cluster
! pg_depend
dependencies between database objects
! pg_description
descriptions or comments on database objects
! pg_group
groups of database users
! pg_index
additional index information
! pg_inherits
table inheritance hierarchy
! pg_language
languages for writing functions
! pg_largeobject
large objects
! pg_listener
asynchronous notification
! pg_namespace
namespaces (schemas)
! pg_opclass
index access method operator classes
! pg_operator
operators
! pg_proc
functions and procedures
! pg_rewrite
query rewriter rules
! pg_shadow
database users
! pg_statistic
optimizer statistics
! pg_trigger
triggers
! pg_type
data types
--- 63,208 ----
! pg_attrdef column default values
! pg_attribute table columns (attributes
, fields
)
! pg_cast casts (data type conversions)
! pg_class tables, indexes, sequences (relations
)
! pg_constraint check constraints, unique / primary key constraints, foreign key constraints
! pg_conversion encoding conversion information
! pg_database databases within this database cluster
! pg_depend dependencies between database objects
! pg_description descriptions or comments on database objects
! pg_group groups of database users
! pg_index additional index information
! pg_inherits table inheritance hierarchy
! pg_language languages for writing functions
! pg_largeobject large objects
! pg_listener asynchronous notification
! pg_namespace namespaces (schemas)
! pg_opclass index access method operator classes
! pg_operator operators
! pg_proc functions and procedures
! pg_rewrite query rewriter rules
! pg_shadow database users
! pg_statistic optimizer statistics
! pg_trigger triggers
! pg_type data types