Thanks Mendola ,
that was a nice idea for functions....
regds
mallah.
On Tuesday 07 May 2002 06:41 pm, Gaetano Mendola wrote:
> "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