pg module

PostgreSQL client backed by libpq. Connect with a conninfo string, a postgresql:// URL, or a map of options. Once connected the interface mirrors sqlite.

import "pg" as pg;

var db = pg.connect({
    host: "localhost", port: 5432, user: "alice",
    password: "secret", database: "myapp"
});

db.exec("INSERT INTO users (name) VALUES ($1)", ["Alice"]);
var rows = db.query("SELECT * FROM users WHERE id = $1", [1]);
print(rows[0].name);

db.close();

Module API

FunctionDescription
pg.connect(conninfo) → dbconninfo can be a libpq keyword string, a postgresql:// URL, or a map of options.
pg.version() → stringlibpq client version, e.g. "16.3.0".
pg.transaction(db, fn)Run fn(db) inside BEGIN/COMMIT.
pg.migrate(db, statements)Idempotent DDL list.
pg.insert(db, table, row) → idConvenience insert + RETURNING id.

db handle

Mirrors sqlite — db.exec, db.query, db.query_one, db.changes, db.close. Use $1, $2, … for parameter placeholders.

See also