insert into "test".test_info( contacts , telephone) values('{"张三", "王五"}' , '{"13869880297","18205321788"}'); res = execute_sql(sql) print(res) # 使用array方法 sql = """ insert into "test".test_info( contacts , telephone) values(array['张三', '王五'] , array['123456789','562345687']); res = execute_sql(sql) print(res) # 批量写入 sql = """ insert into "test".test_info( contacts , telephone) values(%s , %s); rows = [[['张三', '王五'], ['123456789','562345687']], [['赵四', '张三'], ['1232123123','12345678']]] res = execute_many_sql(sql, rows) print(res) # execute_many_sql execute_sql是个人写的工具方法 具体可以使用executemany execute来实现