# pg-tag

**Repository Path**: mirrors_WebReflection/pg-tag

## Basic Information

- **Project Name**: pg-tag
- **Description**: A 10 LOC utility to safely query pg via template literals.
- **Primary Language**: Unknown
- **License**: ISC
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2020-08-19
- **Last Updated**: 2026-01-10

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# pg-tag

[![Build Status](https://travis-ci.com/WebReflection/pg-tag.svg?branch=master)](https://travis-ci.com/WebReflection/pg-tag) [![Coverage Status](https://coveralls.io/repos/github/WebReflection/pg-tag/badge.svg?branch=master)](https://coveralls.io/github/WebReflection/pg-tag?branch=master) [![License: ISC](https://img.shields.io/badge/License-ISC-yellow.svg)](https://opensource.org/licenses/ISC)

<sup>**Social Media Photo by [Hu Chen](https://unsplash.com/@huchenme) on [Unsplash](https://unsplash.com/)**</sup>

A [tiny](https://github.com/WebReflection/pg-tag/blob/master/esm/index.js) utility to safely query [pg](https://www.npmjs.com/package/pg) via template literals.

Available for [SQLite](https://github.com/WebReflection/sqlite-tag/#readme) too.

```js
const {Pool} = require('pg');

const pg = require('pg-tag')(new Pool);

// returns result.rows[0]
const user = await pg.get`
  SELECT
    id, name, address
  FROM
    users
  WHERE
    email = ${email}
`;

// returns result.rows
const users = await pg.all`
  SELECT *
  FROM users
  WHERE status = ${activeUser}
`;

// returns regular pg.query results
await pg.query`
  SELECT *
  FROM users
  WHERE status = ${activeUser}
`;

// allow partial entries
let x = 1;
await pg.all`SELECT * FROM ${raw`table_${x}`}`;

pg.pool.end();
```