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