@sqltags/pg

SqlTags PostgreSQL driver

This is the PostgreSQL driver for the @sqltags/core library.

Please refer to the @sqltags/core project README for more information.

What is SqlTags?

🔧✨ Safely create & execute parameterized SQL queries using template strings.

const [user] = await sql`SELECT * FROM users WHERE id = ${userId}`;

Results in the following query:

SELECT * FROM users WHERE id = $1
-- with parameters: [123]

Installation & Usage

Install:

npm install @sqltags/core @sqltags/pg

Create & connect a PostgreSQL Client or Pool instance, then create a SQL tag using the connection:

import { Client } from 'pg';
import { createPgTag } from '@sqltags/pg';

const client = new Client({
  /* ... */
});
await client.connect();
const sql = createPgTag(client);

import { Pool } from 'pg';
import { createPgTag } from '@sqltags/pg';

const pool = new Pool({
  /* ... */
});
const sql = createPgTag(pool);

Query:

const [user] = await sql`SELECT * FROM users WHERE id = ${userId}`;

Don't forget to disconnect your client when finished!

await client.end();