Re: dropping sequences

Erik Price <eprice@ptc.com> writes:

> Doug McNaught wrote:
>
> > Actually, I'm pretty sure it's "template1".  Where in the docs does it
> > say "template0"?
>
> Maybe it is template1.  I have a DB on my system named template0, but
> I might have created that right when I first installed PostgreSQL as
> an experiment and forgot about it.  I also have a template1 database.

There are both.  template1 is the default, and you can add stuff to it
so newly created databases have the right contents.  template0 is the
"virgin" copy that you use if you accidentally drop or screw up
template1.  :)

-Doug