Assuming that I want to import file chuck.jpg into a table blobs, and the file does not exceed 1000000 bytes, that could be done like this:test=> \lo_import chuck.jpglo_import 152237test=> INSERT INTO blobs VALUES (1, loread(lo_open(152237, 131072), 1000000));INSERT 0 1test=> \lo_unlink 152237lo_unlink 152237我使用 \lo_unlink 来移除临时大对象.I used \lo_unlink to remove the temporary large object. 这篇关于PostgreSQL 加载图片到数据库的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持! 上岸,阿里云!