{"_id":"pg-escape","_rev":"16-b2c9bac0d4b239666d9cea72ff3f78f5","name":"pg-escape","description":"escape postgres queries which do not support stored procedures","dist-tags":{"latest":"0.2.0"},"versions":{"0.0.1":{"name":"pg-escape","version":"0.0.1","repository":{"type":"git","url":"git://github.com/segmentio/pg-escape"},"description":"escape postgres queries which do not support stored procedures","keywords":["pg","postgres","escape","query"],"dependencies":{},"devDependencies":{"mocha":"*","should":"*"},"license":"MIT","bugs":{"url":"https://github.com/segmentio/pg-escape/issues"},"homepage":"https://github.com/segmentio/pg-escape","_id":"pg-escape@0.0.1","dist":{"shasum":"f0ec81ad6ac743302e13926a59a956f78a082955","tarball":"https://registry.npmjs.org/pg-escape/-/pg-escape-0.0.1.tgz","integrity":"sha512-cmWGYCgqO1V434mxIWuNgtF7OLrsBZ/CmUTn4hfFdQjc7dOfj5tI0bl82/ibpvjK7/BUwwpzZyhaEZ3405hO8w==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIQDWGNU9j+yXPRH0O2f2Wu1IsqII1vXv3JtHjN4LFe3qRgIgc9Ic1ruwSxgTCfQH9Lmy2R2Hhuqwtr8RNGJhV+tUL2s="}]},"_from":".","_npmVersion":"1.3.15","_npmUser":{"name":"tjholowaychuk","email":"tj@vision-media.ca"},"maintainers":[{"name":"tjholowaychuk","email":"tj@vision-media.ca"}]},"0.0.2":{"name":"pg-escape","version":"0.0.2","repository":{"type":"git","url":"git://github.com/segmentio/pg-escape"},"description":"escape postgres queries which do not support stored procedures","keywords":["pg","postgres","escape","query"],"dependencies":{},"devDependencies":{"mocha":"*","should":"*"},"license":"MIT","bugs":{"url":"https://github.com/segmentio/pg-escape/issues"},"homepage":"https://github.com/segmentio/pg-escape","_id":"pg-escape@0.0.2","dist":{"shasum":"1e12190fb0fe99801bd85c064f83cf9da15a43cf","tarball":"https://registry.npmjs.org/pg-escape/-/pg-escape-0.0.2.tgz","integrity":"sha512-P+V+a7ygj/vtYR8gWyod+agBPKmhKAfgmrA3lag5TcUTlCYEnyrnTzbMXtGUeNIYZCkQd36blK+PSTASCFQPEg==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIQCpKWGf6b6PfUjdMSH30VlYd8d0vSJyiC6vNE8dxGzQZQIgILx7AUmznOLXlARAG91at8l0Le4tucj2HsugoGj5AfA="}]},"_from":".","_npmVersion":"1.3.15","_npmUser":{"name":"tjholowaychuk","email":"tj@vision-media.ca"},"maintainers":[{"name":"tjholowaychuk","email":"tj@vision-media.ca"}]},"0.0.3":{"name":"pg-escape","version":"0.0.3","repository":{"type":"git","url":"git://github.com/segmentio/pg-escape"},"description":"escape postgres queries which do not support stored procedures","keywords":["pg","postgres","escape","query"],"dependencies":{},"devDependencies":{"mocha":"*","should":"*"},"license":"MIT","bugs":{"url":"https://github.com/segmentio/pg-escape/issues"},"homepage":"https://github.com/segmentio/pg-escape","_id":"pg-escape@0.0.3","dist":{"shasum":"cc7a260d69fea27637a3c96a12659807b6b4fe76","tarball":"https://registry.npmjs.org/pg-escape/-/pg-escape-0.0.3.tgz","integrity":"sha512-1fAGiM9xkCzzAWjqMWE6NCTcH3qercN72Newxqu6AYCbAP6cpTWLcpkFdXxPbTJyjiIOfAXSTcqurPWy86+poA==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEQCIEUTOYBsmf7K1LFzYQTS8OJ4H38d1GKRdM7VwPq11lhsAiBwGqL4qrCZGCr0FuKRwneH49GsYvgAGy/EPRRiX+BqAA=="}]},"_from":".","_npmVersion":"1.3.22","_npmUser":{"name":"tjholowaychuk","email":"tj@vision-media.ca"},"maintainers":[{"name":"tjholowaychuk","email":"tj@vision-media.ca"}]},"0.1.0":{"name":"pg-escape","version":"0.1.0","repository":{"type":"git","url":"https://github.com/segmentio/pg-escape"},"description":"escape postgres queries which do not support stored procedures","keywords":["pg","postgres","escape","query"],"scripts":{"test":"mocha --require should --reporter spec"},"dependencies":{},"devDependencies":{"mocha":"*","should":"*"},"license":"MIT","gitHead":"6028049720220c7bd2917dec80828fcf6ea28cf0","bugs":{"url":"https://github.com/segmentio/pg-escape/issues"},"homepage":"https://github.com/segmentio/pg-escape","_id":"pg-escape@0.1.0","_shasum":"f6d7a47b7bbe531a50eea9b2ea19a391c0893a0a","_from":".","_npmVersion":"2.3.0","_nodeVersion":"0.11.16","_npmUser":{"name":"tjholowaychuk","email":"tj@vision-media.ca"},"maintainers":[{"name":"tjholowaychuk","email":"tj@vision-media.ca"}],"dist":{"shasum":"f6d7a47b7bbe531a50eea9b2ea19a391c0893a0a","tarball":"https://registry.npmjs.org/pg-escape/-/pg-escape-0.1.0.tgz","integrity":"sha512-q7CwWIoZkEZrXbCRquZy1SQhywBtywCw+KvJ2+cWSZRSdYQ4H9wTyIbyWGMotWf6Gl4hDd/pC8djR+3g48r43w==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEQCIE8Ujam+EYf9UhhIWvClUig0G3hZ2lFOvSS+2Hcvc/KGAiAC3gbb4yH1GQFvngN5YVwI9GW7b2Gz1gKwjAizwa9NUw=="}]}},"0.2.0":{"name":"pg-escape","version":"0.2.0","repository":{"type":"git","url":"git+https://github.com/segmentio/pg-escape.git"},"description":"escape postgres queries which do not support stored procedures","keywords":["pg","postgres","escape","query"],"scripts":{"test":"mocha --require should --reporter spec"},"dependencies":{},"devDependencies":{"mocha":"*","should":"*"},"license":"MIT","gitHead":"9fe3a5ab26486829305efd13bf25157ff21279d6","bugs":{"url":"https://github.com/segmentio/pg-escape/issues"},"homepage":"https://github.com/segmentio/pg-escape#readme","_id":"pg-escape@0.2.0","_shasum":"65594c1691659b4ab6e0cbbf9d50744be474998e","_from":".","_npmVersion":"3.3.12","_nodeVersion":"4.2.1","_npmUser":{"name":"tjholowaychuk","email":"tj@vision-media.ca"},"maintainers":[{"name":"tjholowaychuk","email":"tj@vision-media.ca"}],"dist":{"shasum":"65594c1691659b4ab6e0cbbf9d50744be474998e","tarball":"https://registry.npmjs.org/pg-escape/-/pg-escape-0.2.0.tgz","integrity":"sha512-QfXcpxyN9vT+kvexQpTeNyiwCxs4LPXLAV/C0EeLTJPCF61swhGdDlnHcuDgxJudgKGfQYiCkegg0GsSKSvvEg==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEYCIQD3J6dSX2D46SJmb4SnWmTu2LARwbREKuZtfVUQorFXcgIhALnsrWLPU2bs98y3zuhToWDtMO/y6U+Re4QA7fXay6lz"}]}}},"readme":"\n# pg-escape\n\n  Sprintf-style postgres query formatting and escape helper functions.\n\n## Installation\n\n```\n$ npm install pg-escape\n```\n\n## Example\n\n```js\nvar sql = escape('INSERT INTO %I VALUES(%L)', 'books', \"O'Reilly\");\nconsole.log(sql);\n```\n\nyields:\n\n```\nINSERT INTO books VALUES('O''Reilly')\n```\n\n## API\n\n### escape(fmt, ...)\n\n Format the given arguments.\n\n### escape.string(val)\n\n  Format as a simple string.\n\n### escape.dollarQuotedString(val)\n\n  Format as a [dollar quoted string](http://www.postgresql.org/docs/8.3/interactive/sql-syntax-lexical.html#SQL-SYNTAX-DOLLAR-QUOTING)\n\n### escape.ident(val)\n\n  Format as an identifier.\n\n### escape.literal(val)\n\n  Format as a literal.\n\n## Formats\n\n- `%s` formats the argument value as a simple string. A null value is treated as an empty string.\n- `%Q` formats the argument value as a [dollar quoted string](http://www.postgresql.org/docs/8.3/interactive/sql-syntax-lexical.html#SQL-SYNTAX-DOLLAR-QUOTING). A null value is treated as an empty string.\n- `%I` treats the argument value as an SQL identifier, double-quoting it if necessary. It is an error for the value to be null.\n- `%L` quotes the argument value as an SQL literal. A null value is displayed as the string NULL, without quotes.\n- `%%` In addition to the format specifiers described above, the special sequence %% may be used to output a literal % character.\n\n# License\n\n  MIT","maintainers":[{"name":"tjholowaychuk","email":"tj@vision-media.ca"}],"time":{"modified":"2022-06-23T19:39:31.315Z","created":"2014-03-17T17:03:12.887Z","0.0.1":"2014-03-17T17:03:14.300Z","0.0.2":"2014-03-18T16:31:11.863Z","0.0.3":"2014-06-18T17:06:16.130Z","0.1.0":"2015-04-13T23:28:10.842Z","0.2.0":"2015-12-02T17:07:30.725Z"},"readmeFilename":"Readme.md","homepage":"https://github.com/segmentio/pg-escape#readme","keywords":["pg","postgres","escape","query"],"repository":{"type":"git","url":"git+https://github.com/segmentio/pg-escape.git"},"bugs":{"url":"https://github.com/segmentio/pg-escape/issues"},"license":"MIT","users":{"greg00":true,"tjwebb":true}}