sql, postgresql, expressjs, nodejs

pg-promise example select

app.get("/pg", function(req, res) {
    connection.any("SELECT * FROM people", true)
        .then(function(data) {
            res.format({
                "application/json": function() {
					res.status(200).send(data);
                    console.log(data);
                }
            });
        })
        .catch(function(error) {
            console.log("ERROR:", error);
        });
});