Re: Delete function

"Rajesh Kumar Mallah." <mallah@trade-india.com> wrote:
> eg
> regression=> \o command.sql
> regression=> select 'DROP function  ' || proname  from  pg_proc WHERE
proname
> ~ '^sp_';
>
> then psql -f  command.sql

This work fine with the views, unfortunately when you drop a function you
should specify the argument type, so I did in this way (I think is the clean
way):

$ psql -t -c "SELECT 'DROP function ' || proname || ' ('||
oidvectortypes(proargtypes) || ');' from pg_proc WHERE proname ~ '^sp_'" >
todelete.sql
$ psql -f todelete.sql


Ciao
Gaetano