Nick
Explore posts from serversTTCTheo's Typesafe Cult
•Created by Nick on 9/26/2023 in #questions
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?3 replies