lightdb内置特性之http远程调用

LightDB内置了可以直接访问http后端服务的插件

安装http插件

zhangliang[lightdb@localhost ~]$ ltsql postgres
ltsql (13.8-22.3)
Type "help" for help.

lightdb@postgres=# create extension http;
CREATE EXTENSION

请求后端post服务

lightdb@postgres=# select content from http_post('http://ip:port/express/getExpressInfoNdb', '{}', 'application/json');

• 参数1：url
• 参数2：请求报文
• 参数3：报文类型

输出结果

{"result":[{"expressId":"a","orderId":"1","expressNo":"123456789","company":"测试公司1","createDatetime":"20230407010201","status":
"0"},{"expressId":"b","orderId":"2","expressNo":"123456789","company":"测试公司2","createDatetime":"20230407010201","status":"0"}]}