porsager / postgres

Postgres.js - The Fastest full featured PostgreSQL client for Node.js, Deno, Bun and CloudFlare
The Unlicense
7.54k stars 273 forks source link

Does this client support Redshift or other Postgres-compatible databases? #957

Closed satire-foxfire closed 1 month ago

satire-foxfire commented 1 month ago

Libraries like pg appear to work out of the box with any Postgres-compatable database, but if I try this library with Redshift, any and all queries seem to result in a PostgresError: column b.typarray does not exist error regardless of how many tweaks or attempts I make.

Could someone confirm whether this library is intended or designed to work outside of official Postgres itself?

Otherwise, really like the library and would love to use it over pg, but unfortunately I need something that works with Redshift as well :(

porsager commented 1 month ago

Just add fetch_types: false to options 😉

Works with any postgres wire protocol compatible DB

satire-foxfire commented 1 month ago

@porsager Awesome, thanks!