Skip to content

Instantly share code, notes, and snippets.

@Aeon

Aeon/gist:2054750

Created March 17, 2012 03:39
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save Aeon/2054750 to your computer and use it in GitHub Desktop.
Save Aeon/2054750 to your computer and use it in GitHub Desktop.
Download ZIP
psql drop function definitions
Raw
gistfile1.sql
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;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment