Removes a custom Python library from the database. Only the library owner or a superuser can drop a library. DROP LIBRARY cannot be run inside a transaction block (BEGIN … END). For more information, see CREATE LIBRARY.
This command is not reversible. The DROP LIBRARY command commits immediately. If a UDF that depends on the library is running concurrently, the UDF might fail, even if the UDF is running within a transaction.
DROP LIBRARY library_name
The name of the library.