openGauss/MogDB大对象LargeObject存取测试

原作者:彭冲

openGauss/MogDB数据库里bytea二进制类型受segment size编译参数限制,默认不能超过1GB,如果字段存储数据超过1GB可以使用lo(Large Object)扩展类型。

lo类型需要先创建lo extension

解释$ gsql -p5432 -Uomm postgres -r gsql ((MogDB 2.0.1 build f892ccb7) compiled at 2021-07-09 16:15:21 commit 0 last mr ) Non-SSL connection (SSL connection is recommended when requiring high-security) Type "help" for help. postgres=# create extension lo; CREATE EXTENSION