Postgres Pro
Downloads
Home   >   mailing lists

Reloading Template1 - Mailing list pgsql-general

From Hadley Willan
Subject Reloading Template1
Date
Msg-id 1075191236.5381.103.camel@atlas.sol.deeper.co.nz
Whole thread Raw
Responses Re: Reloading Template1  ("V i s h a l Kashyap @ [Sai Hertz And Control Systems]" <sank89@sancharnet.in>)
Re: Reloading Template1  ("V i s h a l Kashyap @ [Sai Hertz And Control Systems]" <sank89@sancharnet.in>)
Re: Reloading Template1  (Richard Huxton <dev@archonet.com>)
Re: Reloading Template1  (Hadley Willan <hadley.willan@deeperdesign.co.nz>)
List pgsql-general
Tree view
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.willan@deeperdesign.com » +64(21) 28 41 463
Deeper Design Limited » +64(7) 377 3328 » www.deeperdesign.com

pgsql-general by date:

Previous
From: Lincoln Yeoh
Date:
Subject: postmaster growing to consume all memory
Next
From: Martijn van Oosterhout
Date:
Subject: Re: postmaster growing to consume all memory