Re: template question . . . - Mailing list pgsql-general

From Larry Rosenman
Subject Re: template question . . .
Date
Msg-id 20011220221900.GA1082@lerami.lerctr.org
Whole thread Raw
In response to template question . . .  ("Peter E. Chen" <pchen3@jhmi.edu>)
List pgsql-general
* Peter E. Chen <pchen3@jhmi.edu> [011220 15:53]:
> Hey All,
>
> Can anyone tell me the difference between the template1 database and the
> template0 database?  When I create new databases should I always use
> template0?
template0 is a virgin copy of the initdb template1 before any user
additions to template1.  It is frozen, and used by the pg_dump scripts
to restore from.

As to whether to use it or not, depends on what is added to template1
in your environment, and what you need at create database time.

LER

>
> Thanks.
>
> Peter
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly

--
Larry Rosenman                     http://www.lerctr.org/~ler
Phone: +1 972-414-9812                 E-Mail: ler@lerctr.org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749

pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Can't use subselect in check constraint
Next
From: Bruno Wolff III
Date:
Subject: Re: Security Question . . .