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@bigfoot.com>
> To: <pgsql-admin@postgresql.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@postgresql.org)
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.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.
