Received: from mailout06.btx.dtag.de (mailout06.btx.dtag.de [194.25.2.154]) by hub.org (8.9.3/8.9.3) with ESMTP id OAA45559 for ; Thu, 15 Jul 1999 14:16:52 -0400 (EDT) (envelope-from dieter.lange@t-online.de) Received: from fwd07.btx.dtag.de ([194.25.2.167]) by mailout06.btx.dtag.de with smtp id 114q3y-0003yO-00; Thu, 15 Jul 1999 20:16:54 +0200 Received: from lghh2.lghh.de (04058915053-0001(btxid)@[193.159.17.17]) by fwd07.btx.dtag.de with smtp id ; Thu, 15 Jul 1999 20:16:37 +0200 Received: (from lg@localhost) by lghh2.lghh.de (8.8.8/8.8.8) id TAA19145 for docs@postgresql.org; Thu, 15 Jul 1999 19:38:02 +0200 Date: Thu, 15 Jul 1999 19:38:02 +0200 To: docs@postgresql.org Subject: Template1 database in docs Message-ID: <19990715193802.A18946@lghh2.lghh.de> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Mailer: Mutt 0.95.4i X-Sender: 04058915053-0001@t-online.de From: dieter.lange@t-online.de (Dieter Lange) Hi, having been a victim of oblivion or superficial reading I should like to suggest a short paragraph on the template1 database - esp. the effect of having tables etc. in it when creating new databases (although the name suggests it: there are too many examples for too many databases around to always be aware this really _is_ a template). Here are the places "found" in my HTML docs tree with "template1": $ find $HTTPROOT/PGSQL -follow -type f -exec strgrep template1 {} \; ==>/usr/local/httpd/htdocs//PGSQL/admin/x1118.htm ==>/usr/local/httpd/htdocs//PGSQL/admin/x2035.htm ==>/usr/local/httpd/htdocs//PGSQL/admin/x760.htm ==>/usr/local/httpd/htdocs//PGSQL/postgres/app-createdb.htm ==>/usr/local/httpd/htdocs//PGSQL/postgres/app-createuser.htm ==>/usr/local/httpd/htdocs//PGSQL/postgres/app-destroydb.htm ==>/usr/local/httpd/htdocs//PGSQL/postgres/app-destroyuser.htm ==>/usr/local/httpd/htdocs//PGSQL/postgres/app-initdb.htm ==>/usr/local/httpd/htdocs//PGSQL/postgres/app-pg-dump.htm ==>/usr/local/httpd/htdocs//PGSQL/postgres/app-pg-dumpall.htm ==>/usr/local/httpd/htdocs//PGSQL/postgres/app-vacuumdb.htm ==>/usr/local/httpd/htdocs//PGSQL/postgres/bki.htm ==>/usr/local/httpd/htdocs//PGSQL/postgres/sql-createdatabase.htm ==>/usr/local/httpd/htdocs//PGSQL/postgres/x12372.htm ==>/usr/local/httpd/htdocs//PGSQL/postgres/x12730.htm ==>/usr/local/httpd/htdocs//PGSQL/postgres/x13647.htm ==>/usr/local/httpd/htdocs//PGSQL/postgres/x17776.htm ==>/usr/local/httpd/htdocs//PGSQL/postgres/x18163.htm ==>/usr/local/httpd/htdocs//PGSQL/postgres/x22670.htm ==>/usr/local/httpd/htdocs//PGSQL/postgres/x22687.htm ==>/usr/local/httpd/htdocs//PGSQL/postgres/x3010.htm ==>/usr/local/httpd/htdocs//PGSQL/postgres/xplang.htm ==>/usr/local/httpd/htdocs//PGSQL/programmer/bki.htm ==>/usr/local/httpd/htdocs//PGSQL/programmer/x3628.htm ==>/usr/local/httpd/htdocs//PGSQL/programmer/x4015.htm ==>/usr/local/httpd/htdocs//PGSQL/programmer/xplang.htm ==>/usr/local/httpd/htdocs//PGSQL/tutorial/x1129.htm ==>/usr/local/httpd/htdocs//PGSQL/tutorial/x1146.htm ==>/usr/local/httpd/htdocs//PGSQL/user/app-createdb.htm ==>/usr/local/httpd/htdocs//PGSQL/user/app-createuser.htm ==>/usr/local/httpd/htdocs//PGSQL/user/app-destroydb.htm ==>/usr/local/httpd/htdocs//PGSQL/user/app-destroyuser.htm ==>/usr/local/httpd/htdocs//PGSQL/user/app-initdb.htm ==>/usr/local/httpd/htdocs//PGSQL/user/app-pg-dump.htm ==>/usr/local/httpd/htdocs//PGSQL/user/app-pg-dumpall.htm ==>/usr/local/httpd/htdocs//PGSQL/user/app-vacuumdb.htm ==>/usr/local/httpd/htdocs//PGSQL/user/sql-createdatabase.htm ==>/usr/local/httpd/htdocs//PGSQL/user/x3310.htm Regards! D.L. ------------------------------------------------------------------------------ Dr.-Ing.Dieter Lange ------------------------------------------------------------------------------