0.3.6 • Published 11 months ago
@postgresql-typed/pg v0.3.6
npm install --save @postgresql-typed/pg
npm install --save-dev @postgresql-typed/cli
# Generate types
npx pgt gen
import { Client, isReady } from "@postgresql-typed/pg";
import { Databases, DatabasesData } from "./__generated__/index.js";
const client = await new Client<Databases>(
DatabasesData,
process.env.DATABASE_URI
).testConnection();
if (!isReady(client)) {
throw new Error("Client not ready");
}
const table = client.table("<your table path>");
const result = await table.select.execute("*");
if (!result.success) {
throw new Error("Failed to select");
}
console.log(result.data.rows);