uninstall_lo.sql

来自「PostgreSQL 8.2中增加了很多企业用户所需要的功能和性能上的提高,其开」· SQL 代码 · 共 16 行

--
-- This removes the LO type
-- It's used just for development
--

-- Adjust this setting to control where the objects get created.
SET search_path = public;

-- drop the type and associated functions
DROP TYPE lo CASCADE;

-- the trigger function has no dependency on the type, so drop separately
DROP FUNCTION lo_manage();

-- the lo stuff is now removed from the system