Scott Watermasysk Husband, Father, Bootstrapper, Developer, Builder, Shipper.

TIL: Do Not Name a Postgres Table User

Working through a handful of JavaScript ORM tools and twice today I accidentally created a table called User.

This conflicts with Postgresā€™s own User table. Postgres is OK with this assuming you use quotes around user in your queries (and it becomes case sensitive).

Loosely translated, do not name your table User. I guess if you are switching databases, the above is necessary, but it is probably just as easy to rename your table at that point.