docs icon indicating copy to clipboard operation
docs copied to clipboard

Hint for queryRaw with PostgreSQL: Postgres lowercases without double quotes + have to prefix table with schema name

Open nikolasburk opened this issue 5 years ago • 2 comments

Users that are not used to querying PostgreSQL directly but need to use queryRaw for some reason can easily get confused because of some Postgres behaviour, here is an example of that confusion: https://github.com/prisma/prisma/discussions/2664

It would be nice to have a section in the docs that quickly mentions these "gotchas" when querying Postgres with raw SQL.

nikolasburk avatar Jul 02 '20 09:07 nikolasburk

A more elaborate version of that would be a great thing for the dataguide possibly.

janpio avatar Jul 02 '20 10:07 janpio

Add to: https://www.prisma.io/docs/concepts/components/prisma-client/raw-database-access#considerations

nikolasburk avatar Mar 27 '23 16:03 nikolasburk