Re: [DOCS] Re: [GENERAL] Re: [HACKERS] [Fwd: SGVLLUG Oracle and Informix on Linux]y

> >
> > > 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)