node-postgres
node-postgres copied to clipboard
brianc
PostgreSQL client for node.js.
Hello there, I use node-postgres since months and now my project is evolving so I migrated on a more robust setup. I was using node-postgres pooling to manage the pool...
SYSTEM: - Node: ^16.0.0 - pg:^8.7.3 - pg-connection-string: ^2.6.0 - macOS m1 pro Monterey 12.6 - bash - postgres: 14 when instantiating a new `pg.client({})` object, when using `pg-connection-string` version...
From v16 the postgres client supports a special `sslrootcert` connection string param that uses the system root certificate storage. It would be great if node-postgres would also support this param...
Thanks for the library! Had an issue with what probably is an edge-case, using unix sockets on windows. UNIX sockets are supported by postgresql on windows (I can start and...
Hope that through the configuration can be specified default schema, like this var cn = { host: 'localhost', port: 5432, database: 'MyDB', user: 'user1', password: 'pw', currentSchema:'C0001' }; thanks!
support esm
when running this package inside an ESM project, I got this error ``` import { Pool } from 'pg'; ^^^^ SyntaxError: Named export 'Pool' not found. The requested module 'pg'...
I am using the following query to retrieve users from database, and before this one i just perform a count(*) to retrieve the total number of users. ``` SELECT coalesce(json_agg(_0_users),'[]')...
Context: We are trying to switch from [data-api-client](https://github.com/jeremydaly/data-api-client) to pg. Our setup is: Aurora serverelss V1 PostgresSQL 11.16 cluster. However, we are not able to connect - instead the connection...
Hello! Hailing from [@subsquid](https://github.com/subsquid). We've ran into an issue related to how `pg` handles `numeric` arrays. Unlike `numeric` scalars that are returned as strings, arrays are decoded into `number` s,...
Sets `extra_float_digits` setting to 1 when connecting to DB. For older (
