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_';
Ciao Gaetano.
----- Original Message -----
From: "Gaetano Mendola" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
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 [EMAIL PROTECTED])
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
