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