> >
> > > Okay, I've suspected there was more to "template1" for a little while now,
> > > but I'd not gotten around to looking into it more. Still, my first
> > > impression was it was a sample database. ;) Maybe a name like "master"
> > > would be clearer, or maybe that means something else to someone.
> > >
> >
> > Yes, master would be a better name than template1.
>
>
> I disagree. template1 is not only the "master" database, it is also used as
> as the template when creating a new database. That is, if you want to create
> all your databases with certain characteristics (say installed functions or
> types or something) you can set up template1 the way you want, dump it to
> the template dump file and then any new db will be created with your
> customization. So template1 really is a discriptive term.
Good point.
--
Bruce Momjian | 830 Blythe Avenue
maillist@candle.pha.pa.us | Drexel Hill, Pennsylvania 19026
+ If your life is a hard drive, | (610) 353-9879(w)
+ Christ can be your backup. | (610) 853-3000(h)