1.What is PostgREST

PostgreSQL+ RESTful

2.下载解压

$ wget https://github.com/PostgREST/postgrest/releases/download/v6.0.2/postgrest-v6.0.2-centos7.tar.xz
$ xz -d postgrest-v6.0.2-centos7.tar.xz
$ tar -xvf postgrest-v6.0.2-centos7.tar
复制

3.编辑配置文件 db.conf

db-uri = "postgres://flylinker:123456@127.0.0.1:5555/flylinker"
db-schema = "public"
db-anon-role = "flylinker"
server-host = "0.0.0.0"
server-port = 6666
复制

4.启动postgrest服务监听6666端口

$ ./postgrest db.conf
Attempting to connect to the database...
Listening on port 6666
Connection successful
复制

5.创建测试表并插入数据

create table test (
 id serial primary key,
 info text,
 ctime timestamptz
);

insert into test (info,ctime) values ('佩奇',now()), ('乔治',now());
复制

6.使用postman测试

7.查询规则

http://192.168.99.200:6666/test?select=id,info,ctime&id=eq.2&order=id.desc&limit=2

url中包含表名?select=字段名1,字段名2&过滤条件字段=比较运算符.值&order=排序字段.正序&limit=数量

更多运算操作符 http://postgrest.org/en/latest/api.html#operators