Re: Delete function

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" <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)