From: | Hadley Willan <hadley(dot)willan(at)deeperdesign(dot)co(dot)nz> |
---|---|
To: | PGSQL General <pgsql-general(at)postgresql(dot)org> |
Subject: | Reloading Template1 |
Date: | 2004-01-27 08:13:56 |
Message-ID: | 1075191236.5381.103.camel@atlas.sol.deeper.co.nz |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
--
Hadley Willan » Director » hadley(dot)willan(at)deeperdesign(dot)com » +64(21) 28
41 463
Deeper Design Limited » +64(7) 377 3328 » www.deeperdesign.com
From | Date | Subject | |
---|---|---|---|
Next Message | Martijn van Oosterhout | 2004-01-27 08:41:29 | Re: postmaster growing to consume all memory |
Previous Message | Lincoln Yeoh | 2004-01-27 07:42:09 | postmaster growing to consume all memory |