From a25b94c080a644a66983bbcf82a4e358aa47b7df Mon Sep 17 00:00:00 2001
From: Tom Lane <tgl@sss.pgh.pa.us>
Date: Fri, 22 Mar 2002 21:34:44 +0000
Subject: Create the pg_namespace system catalog.  Doesn't do much yet, but
 it's there and CREATE SCHEMA will make entries in it...

---
 doc/src/sgml/catalogs.sgml | 57 +++++++++++++++++++++++++++++++++++++++++++++-
 1 file changed, 56 insertions(+), 1 deletion(-)

(limited to 'doc/src')

diff --git a/doc/src/sgml/catalogs.sgml b/doc/src/sgml/catalogs.sgml
index b72b0836179..5371da7ee7e 100644
--- a/doc/src/sgml/catalogs.sgml
+++ b/doc/src/sgml/catalogs.sgml
@@ -1,6 +1,6 @@
 <!--
  Documentation of the system catalogs, directed toward PostgreSQL developers
- $Header: /cvsroot/pgsql/doc/src/sgml/catalogs.sgml,v 2.36 2002/03/22 19:20:03 petere Exp $
+ $Header: /cvsroot/pgsql/doc/src/sgml/catalogs.sgml,v 2.37 2002/03/22 21:34:43 tgl Exp $
  -->
 
 <chapter id="catalogs">
@@ -111,6 +111,11 @@
       <entry>asynchronous notification</entry>
      </row>
 
+     <row>
+      <entry>pg_namespace</entry>
+      <entry>namespaces (schemas)</entry>
+     </row>
+
      <row>
       <entry>pg_opclass</entry>
       <entry>index access method operator classes</entry>
@@ -1408,6 +1413,56 @@
  </sect1>
 
 
+ <sect1 id="catalog-pg-namespace">
+  <title>pg_namespace</title>
+
+  <para>
+   A namespace is the structure underlying SQL92 schemas: each namespace
+   can have a separate collection of relations, types, etc without name
+   conflicts.
+  </para>
+
+  <table>
+   <title>pg_namespace Columns</title>
+
+   <tgroup cols=4>
+    <thead>
+     <row>
+      <entry>Name</entry>
+      <entry>Type</entry>
+      <entry>References</entry>
+      <entry>Description</entry>
+     </row>
+    </thead>
+
+    <tbody>
+     <row>
+      <entry>nspname</entry>
+      <entry><type>name</type></entry>
+      <entry></entry>
+      <entry>Name of the namespace</entry>
+     </row>
+
+     <row>
+      <entry>nspowner</entry>
+      <entry><type>int4</type></entry>
+      <entry>pg_shadow.usesysid</entry>
+      <entry>Owner (creator) of the namespace</entry>
+     </row>
+
+     <row>
+      <entry>nspacl</entry>
+      <entry><type>aclitem[]</type></entry>
+      <entry></entry>
+      <entry>Access permissions</entry>
+     </row>
+    </tbody>
+   </tgroup>
+  </table>
+
+ </sect1>
+
+
  <sect1 id="catalog-pg-operator">
   <title>pg_operator</title>
 
-- 
cgit v1.2.3