Return to Snippet

Revision: 10053
at December 5, 2008 00:38 by robe


Initial Code
--Below generates sql to delete functions in a particular schema
SELECT 'DROP FUNCTION ' || quote_ident(ns.nspname) || '.' || quote_ident(proname) || '(' || oidvectortypes(proargtypes) || ');'
FROM pg_proc INNER JOIN pg_namespace ns ON (pg_proc.pronamespace = ns.oid)
WHERE ns.nspname = 'my_messed_up_schema'  order by proname;

Initial URL

                                

Initial Description

                                

Initial Title
Delete many functions

Initial Tags

                                

Initial Language
SQL