pg-escape

Sprintf-style postgres query formatting and escape helper functions.

Installation

``
$ npm install pg-escape
`

Example

`js
var sql = escape('INSERT INTO %I VALUES(%L)', 'books', "O'Reilly");
console.log(sql);
`

yields:

`
INSERT INTO books VALUES('O''Reilly')
`

API

$3

Format the given arguments.

$3

Format as a simple string.

$3

Format as a dollar quoted string

$3

Format as an identifier.

$3

Format as a literal.

Formats

- %s formats the argument value as a simple string. A null value is treated as an empty string.
- %Q formats the argument value as a dollar quoted string. A null value is treated as an empty string.
- %I treats the argument value as an SQL identifier, double-quoting it if necessary. It is an error for the value to be null.
- %L quotes the argument value as an SQL literal. A null value is displayed as the string NULL, without quotes.
- %%` In addition to the format specifiers described above, the special sequence %% may be used to output a literal % character.

License

MIT