Name

Status

Synopsis

local cjson = require 'cjson'
local postgres = require 'resty.postgres'
local strfmt = string.format
local db, err = postgres:connect('host=localhost user=xx dbname=xx')
if err then
 -- has error, exit
end
local version, err = db:version()
if not err then
 print(cjson.encode(version))
 -- out:
 -- {"lib":90601, "server":90601}
end
local rows, err = db:query('SELECT tableowner, tablename FROM pg_tables LIMIT 2')
if not err then
 print(cjson.encode(rows))
 -- out:
 -- [{"tablename":"products","tableowner":"xx"},{"tablename":"pg_statistic","tableowner":"postgres"}}]
end
local num, err = db:execute("UPDATE xx SET xx='hahaha' WHERE xx=xx")
-- check error
if not err then
 print('update rows:' .. num)
end
db:close()

Dependencies

Author