Common Problems with PostgreSQL

Last updated:

Existing columns causing an error when using Custom Query

Double-check if your column names contain any uppercase characters. This will cause an error, as by default they are converted to lowercase. To fix your query, you’ll need to wrap the column name in double quotes.

In the example below, you’ll want to put double quotes around the column named myStatus.
SELECT id, “myStatus” FROM my_table LIMIT 50;

Need More Help?

Contact Support

Tell us about your problem, and we’ll find you a solution or you can email support.
Get Help

Hire an Expert

We have a directory of professionals across the globe who are ready to help.
Find a Zapier Expert

Zapier Community

Connect with other Zapier users and industry professionals to get help crafting the perfect workflow.
Check out the community