| 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: | Whole Thread | Raw Message | 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 |