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