DEV Community

Discussion on: Don't get bit by PostgreSQL case sensitivity

Collapse
 
biolabanalytics profile image
Bio Lab Analytics, LLC

Thank you very much for writing this up! I've been using pgSQL for a long time as a standalone Db (with pgAdmin4) or as a back-end for R/shiny apps, and somehow never ran into this issue. I've been working with Python/Flask and a Flask-SQLAlchemy ORM more recently, and this was almost a showstopper when I went in to validate my commits in pgSQL and saw the cryptic error messages! Your post probably saved me hours of banging my head against the keyboard in frustration :)