Re: Reloading Template1

On Tuesday 27 January 2004 08:13, Hadley Willan wrote:
> Hello,
>     I've accidently created a whole bunch of tables and sequences in
> template1.
>
> I didn't actually want the information in template1 but with the slip of
> a key my script piped all the commands into it and now all the info is
> there, doh!.

We all have doh! moments, you are not the first to be here.

> How to I recreate an empty template1?

Two options:
1. Manually undo all the changes (no, didn't think you liked that one)
2. Drop template1 and recreate it using template0

The createdb command has a flag to let you base your new database on something
other than template1. Actually, IIRC this is exactly why we have template0 -
for those occasions where you want to regenerate template1.

--
  Richard Huxton
  Archonet Ltd