Connect to Postgres

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

Import the Postgres package from

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

await sql.end();

Run this example locally using the Deno CLI:

deno run --allow-net --allow-env https://docs.deno.com/examples/scripts/postgres.ts

Did you find what you needed?