Can't list users - "select * from user" returns only one row with one column
Ok this is kind of a stupid question, but I'll leave it in case someone else makes a similarly dumb mistake.

For the record, I'm not the one who created a set of models including user instead of users.

Postgres has its own table user which it holds postgres users in. When you select * from user what you're getting is the result of the postgres user table. What you have to do instead is select * from "user" where user is in double quotes.