Hey guys queryraw doesn't work for me, data appear...
# orm-help
a
Hey guys queryraw doesn't work for me, data appear on prisma studio and there is no problem but when I try to run the query: const users = await prisma.$queryRaw`SELECT * FROM User`; , It only shows my postgres username. When I check my data on psql, It shows the same, tables appear but there is no data inside.
n
Hey 👋 You need to use the database schema name while querying your data.
Copy code
const users = await prisma.$queryRaw`SELECT * FROM "public"."User"`;
a
Oooh thank you so mutch, that solved the problem
🙌 1