Unable to delete an entry in a Postgres DB on Vercel

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?

Hi, @allthingssmitty!

Postgres is case-sensitive when it comes to unquoted identifiers. If your column was created with quotes (e.g., “Email” instead of email), you need to use quotes in your query. For example:

SELECT *
FROM "User"
WHERE "email" LIKE '%test%'

Can you give that a go?

This topic was automatically closed 2 days after the last reply. New replies are no longer allowed.