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