Scott Watermasysk Husband, Father, Bootstrapper, Developer, Keyboarder, Pained Sixers Fan.

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.