Re: cleaning up useless pl/pgsql functions

Dnia 2003-06-30 23:13, Użytkownik Tomasz Myrta napisał:
> Hi
> Do you have any easy script to remove all pl/pgsql function? After a lot 
> of changes inside "create or replace function..." scripts I have a big 
> mess. I want to remove all user defined pl/pgsql functions and restore 
> some of them from my scripts again.
> 
> 
> Regards,
> Tomasz Myrta

Hmm Answer to myself:

DELETE from pg_proc where prolang =(select oid from pg_language where 
lanname='plpgsq');

What do you think about it?

Tomasz