Can't list users - "select * from user" returns only one row with one column I have a heroku postgres add-on database with a user table. However, when I attempt to select * from user, all I get is:

  current_user  
----------------
 rtsjlhdfptlaqd
(1 row)


The table name is definitely user. There is no users table. There are definitely a bunch of users in my app, but I can't seem to list them. 

Thoughts?
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.