postgresql 使用lo模块扩展更方便操作

安装模块扩展

安装
CREATE EXTENSION [ IF NOT EXISTS ] extension_name
    [ WITH ] [ SCHEMA schema_name ]
             [ VERSION version ]
             [ CASCADE ]


卸载扩展
DROP EXTENSION [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]

安装 lo 模块扩展 

CREATE EXTENSION lo;

另一个扩展为vacumlo移除孤立大对象,

vacuumlo — remove orphaned large objects from a PostgreSQL database

测试触发器作用

CREATE TABLE image (title text, raster lo);

CREATE TRIGGER t_raster BEFORE UPDATE OR DELETE ON image
    FOR EACH ROW EXECUTE FUNCTION lo_manage(raster);

refs

PostgreSQL: Documentation: 14: F.20. lo