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.