node-postgres
node-postgres copied to clipboard
brianc
PostgreSQL client for node.js.
When listing the node versions, I noticed that I was forever waiting for pool.connect() to process. ```ts import {Client, Pool} from "pg"; import * as fs from "fs"; import *...
Hello, I have simple code like this: ```javascript var pg = require("pg"); const client = new pg.Client(); // ... client.query({ text: "SELECT num FROM data WHERE id = $1", values:...
We are trying to build this query ``` const { sessionIds, moderatorIds, payouts, createdAts, publicAts } = normalizedData; const usersIds = ['uuid0, 'uuid1'] const createdAts = ['NOW()', 'NOW()'] const publicAts...
When storing an array to a JSON type column (either json or jsonb), an empty [] is returned as {} on the SELECT This appears to be because arrays are...
When using PGSSLMODE env in native mode, an invalid database URL string is constructed with sslmode=true/false.
I tried to follow along with the example provided but when i run this code i get an error, stream.pipe is not a function. Im new to pg and nodeJS...
## Description On node v16.13.0, connecting to the database works as expected. I decided to try out the changes in v17.0.1 and I can't connect to the db anymore. ##...
I'm having an issue with parameters being converted from numbers to strings before being passed to the pg server. Here are the test cases using Typescript + Mocha + Chai:...
As of Node 15 you can use AbortController to abort promises. From what I gather, this is not yet supported by node-postgres, and I would like to know if this...
Hi, I keep getting error that the relation doesn't exist, when it does. For example, I have a collection called Shops. I use the following code to get the data:...
