DROP [ PROCEDURAL ] LANGUAGE 'name'
Use the DROP PROCEDURAL LANGUAGE command to remove the definition of the procedural language named name.
DROP LANGUAGE does not check to make sure that functions and triggers you have registered for use with this language have been removed. Be sure that no existing functions in your database rely on a language before dropping it.
The following example removes the plexample language from the booktown database:
booktown=# DROP PROCEDURAL LANGUAGE 'plexample'; DROP