PostgreSQL删除所有大型对象

default

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11


-- 删除所有大型对象
DO $$
DECLARE
    lo_oid oid;
BEGIN
    FOR lo_oid IN 
        SELECT oid FROM pg_largeobject_metadata 
    LOOP
        PERFORM lo_unlink(lo_oid);
    END LOOP;
END $$;