postgres
postgres copied to clipboard
porsager
Postgres.js - The Fastest full featured PostgreSQL client for Node.js, Deno, Bun and CloudFlare
closes #807, to add `sql.join`: ```js let dynamicFilters = [ sql`somecol = ${somevalue}`, sql`col2 = ${v2}` ]; const dynamicColumns = [sql('somecol'), sql('col2')]; await sql` select ${sql.join(sql`, `, dynamicColumns)} from t...
Hey, We're noticing big delays on certain transactions, we tracked it down to be the 'fetch types' functionality that queries `select b.oid, b.typarray from pg_catalog.pg_type a left join pg_catalog.pg_type b...
I've seen previous issues filed and resolved for this. However, it does not seem to be fixed. There is not a clear way to pass input into the copy command...
Getting the following error when it fails to establish connection. More context: - this only happens when i try to run my nodejs server while postgresql db server is off...
This PR fixes #862 by ensuring classes defined under the `postgres` namespace aren't also available as a named export, but only under the default `postgres.` export. I've tested the change...
I've a columns variable in which I'm conditionally adding column name based on whether field is enable or not. There is one field `createdBy` which I want to select as...
Hello! I'm having problems when `accessing / filtering on / ordering by` I'm able to query with a hardcoded query from a file or using the unsafe method, but... when...
So, I was having an issue where my current in development web service endpoint would become completely unresponsive. Tracing showed that when it happens, what happens is it just goes...
Consider the following code: ```js const ids = ['ab11cd', 'ef22gh'] await sql` select student_id, max(version) as version from students where student_id in (${sql(ids)}) group by student_id ` ``` This would...
String with `'` characters should be escaped to `''` currently syntax error is thrown for such strings.
