From: | Hadley Willan <hadley(dot)willan(at)deeperdesign(dot)co(dot)nz> |
---|---|
To: | PGSQL General <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Reloading Template1 |
Date: | 2004-01-27 20:42:02 |
Message-ID: | 1075236121.5381.132.camel@atlas.sol.deeper.co.nz |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Thanks everybody for your help.
It was a pretty simple procedure at the end of the day and I've learned
a valuable lesson, remember which DB its all going to!
Thanks again.
Hadley
On Wed, 2004-01-28 at 10: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!.
>
> Problem is now that I try to create the DB I want, all the view and
> structures are already there.
>
> How to I recreate an empty template1?
>
> Thanks
>
From | Date | Subject | |
---|---|---|---|
Next Message | Johannes Barop | 2004-01-27 20:42:07 | Call a function when a User (dis)connects from the Server/Database |
Previous Message | Reece Hart | 2004-01-27 20:30:57 | Re: Foreign keys on inherited attributes |