Question
I have a Postgres DB on Vercel (the free version) with some data in it and I’m trying to do what I think should be a very straightforward deletion of an entry in the database.
SELECT *
FROM User
WHERE email LIKE '%test%'
When I run the query on the storage tab of my project, get the following error:
Syntax error: column "email" does not exist.
Of course if I use the browse function for this table I can see the “email” column exists and the row that I wish to delete has an email that contains “test” in it, matching my query. Any thoughts how I might be able to do this?