PostgreSQL | Functions

List Functions

SELECT p.proname
  FROM pg_catalog.pg_namespace n
       JOIN pg_catalog.pg_proc p ON p.pronamespace = n.oid
 WHERE n.nspname = 'public'

Drop a Function

DROP FUNCTION {function_name}

Reference