node-postgres
node-postgres copied to clipboard
brianc
PostgreSQL client for node.js.
Related to #2012. Since we cannot disambiguate between Arrays that should be converted to PostgreSQL array types and Arrays that should be treated as JSON, make it at least possible...
To view:https://node-postgres.com/features/types ->date / timestamp / timestamptz **create table:** > CREATE TEMP TABLE dates( > date_col DATE, > timestamp_col TIMESTAMP, > timestamptz_col TIMESTAMPTZ, > ); **Insert first,then query.** > E:\nodejs_space\hello>node...
Hello, the company I work for has been using `pg-promise` for our database service and we've run into an issue with failover, which we believe is an error in the...
I have an app that connects to multiple PG instances. When a `pg` client/pool encounters an error, the only way to know which database was the culprit is to have...
pg version: 8.3.0 I've contrived the example a bit here, but let's say I wanted to run the following statement: ```sql UPDATE users SET settings = CASE WHEN $1 IS...
There's a problem in [pg-query-stream] where it fails to reject a `iterator.next()` request when the connection breaks. Here's example, using a little modified code from [pg-query-stream]: ```ts const pg =...
Thank you so much for all the effort you’ve put into this. I am currently trying to integrate with OpenNext Cloudflare, but I’m encountering an error in the stream.ts file...
sslnegotiation This option controls how SSL encryption is negotiated with the server, if SSL is used. In the default postgres mode, the client first asks the server if SSL is...
This PR is just an extension for https://github.com/brianc/node-postgres/pull/3289. It aims to solve the message ordering issues described in #3174 for [this single particular case](https://github.com/brianc/node-postgres/issues/3174#issuecomment-2473394510) involving the use of cursors.
This PR introduces three changes to make the pg package more compatible with Deno while keeping full Node.js functionality: 1. **Default user value** - Replace `user: process.platform === 'win32' ?...
