Re: Delete function

On Tuesday 07 May 2002 03:47 pm, Gaetano Mendola wrote:
> I did this but I don't know if is the correct way:
>
> DELETE FROM pg_proc WHERE proname ~ '^sp_';
> DELETE FROM pg_class WHERE relname ~ '^v_';

hmm..

i dont think its safe to fiddle with the system catalogs like that.

There exists SQL commands for that like
DROP FUNCTION <function_name>
or DROP VIEW <view_name>

of course there is a limitation(read advantage) that they do not understand
pattern matches

but it is easy to overcome it using SQL to create a batch of SQL commands.

eg
regression=> \o command.sql
regression=> select 'DROP function ' || proname from pg_proc WHERE proname
~ '^sp_';

then psql -f command.sql

regds
mallah.

>
> Ciao Gaetano.
>
>
>
>
> ----- Original Message -----
> From: "Gaetano Mendola" <mendola(at)bigfoot(dot)com>
> To: <pgsql-admin(at)postgresql(dot)org>
> Sent: Tuesday, May 07, 2002 9:28 AM
> Subject: [ADMIN] Delete function
>
> > Hi all,
> > How can I delete all function that match some name rules?
> > Ex:
> > I want delete all functions that matches sp_*
> > and all views that matches v_*
> >
> >
> >
> > Ciao
> > Gaetano
> >
> > --
> > #exclude <windows>
> > #include <CSRSS>
> > printf("\t\t\b\b\b\b\b\b");.
> > printf("\t\t\b\b\b\b\b\b");
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 2: you can get off all lists at once with the unregister command
> > (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly

--
Rajesh Kumar Mallah,
Project Manager (Development)
Infocom Network Limited, New Delhi
phone: +91(11)6152172 (221) (L) ,9811255597 (M)

Visit http://www.trade-india.com ,
India's Leading B2B eMarketplace.