Theo's Typesafe CultTTC
Theo's Typesafe Cult3y ago
2 replies
Nick

How to query verceldb postgres database on vercel.com?

I created a postgres database using Vercel's Postgres solution (https://vercel.com/docs/storage/vercel-postgres).

I have a local project with the usual T3 stuffs, where I created two Models (Landmark and Image). I added some data manually, so I headed to the vercel.com storage view where you can browse your database on their website. Good news, the Browse tab works - I can see both tables and the data in them!

But then I found the Query tab. I typed in SELECT * FROM landmarks; and it throws Syntax error: relation "landmark" does not exist.. I've tried any number of FROM landark;, from verceldb.landmarks, FROM Landmark;, all with the same error.

What am I missing here? To reference them directly, do they have a special name?
Was this page helpful?