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