Re: dropping template1

Thomas T. Thai wrote:
 >Shridhar Daithankar wrote:
 >>On 9 Jan 2003 at 1:14, Thomas T. Thai wrote:
 >>
 >>>I'm using 7.3 and accidently created unnecessary functions and such i
 >>>template1. Originally it had nothing added beyond the initial install
 >>>(initdb). I would like to return it to the clean state.
 >>
 >>How about drop function?
 >
 > there are lots of functions and datatypes etc. is there an easier way?

Unless you did weird things, all functions and datatypes will be in
non-system schema's. Dropping and recreating the schema's will
implicitly drop the functions and datatypes as well. Don't forget to
vacuum freeze after that.

Jochem