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