Today I learnt about the Postgres
user function. While working on my side project Focust I saw some strange behaviour trying to to select all users from my user table:
select * from user; user ------------ petegraham (1 row)
It turns our that
user is a keyword in Postgres which gets the current user so to select from the table I need to run
select * from "user";. Here’s a more in-dept explanation.