"Rajesh Kumar Mallah." <mallah(at)trade-india(dot)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