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 <dieter.lange@t-online.de>
------------------------------------------------------------------------------