Connect to Postgres

Using the npm Postgres client, you can connect to a Postgres database running anywhere.

Import the Postgres package from npm

import postgres from "npm:postgres";

Initialize the client with connection information for your database, and create a connection.

const sql = postgres({
  user: "user",
  database: "test",
  hostname: "localhost",
  port: 5432,
});

Execute a SQL query

const result = await sql`
  SELECT ID, NAME FROM PEOPLE
`;
console.log(result);

Close the connection to the database

Run this example locally using the Deno CLI:

deno run -N -E https://docs.deno.com/examples/scripts/postgres.ts

Did you find what you needed?