cleaning out template1, and what is template0? - Mailing list pgsql-general

From Louis-David Mitterrand
Subject cleaning out template1, and what is template0?
Date
Msg-id 20010215170215.A4347@apartia.ch
Whole thread Raw
Responses Re: cleaning out template1, and what is template0?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
It sometimes happens that template1 gets accidentally littered with
tables and sequences intended for other databases (forget to \connect,
wrong arg to psql, etc.).

Is it safe to DROP/CREATE template1 for a radical cleanout or should I
merely remove cruft by the item?

In Pg-7.1 there is a new template0 db. What is it used for?

Thanks in advance,

--
    THESEE: Quel coup me l'a ravi ? Quelle foudre soudaine ?
 THERAMENE: A peine nous sortions des portes de Tr�z�ne,
            Il �tait sur son char. Ses gardes afflig�s
            Imitaient son silence, autour de lui rang�s ;
                                          (Ph�dre, J-B Racine, acte 5, sc�ne 6)

pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: regular expression substittion function?
Next
From: Bruce Momjian
Date:
Subject: Re: regular expression substittion function?