Unexpected results when querying a table called 'user'

[pifantastic]

Queries to all other tables work as expected. When I query a table called 'user', it seems to return records from some other table, perhaps postgres' table internally representing database users.

  client.query("SELECT * FROM user", function(err, data) {
    console.log(client, err, data);
  });

returns

{ _queryQueue: [], _namedQueries: {}, _activeQuery: { text: 'SELECT * FROM user', values: [], callback: [Function], rows: [ [Object] ] }, _config: { database: 'mydb_development', user: 'mydbuser', password: 'mydbpass', host: undefined, port: 5432 }, _events: { connect: [Function], _row: [Function], _error: [Function], _readyForQuery: [Function] }, _connected: true } null { rows: [ { current_user: 'mydbuser' } ] }

However, if I duplicate my users table and name it differently, say 'user_copy', everything works as expected. The easy workaround is to just change the name of my user table.

[pifantastic]

Gah, this appears to be a postgres thing and not related to your module. I apologize!

[pifantastic]

As a follow up, what I was doing wrong: user is a reserved word in Postgres so a query like SELECT * FROM user returns the current database user. This is fixed by properly quoting the table name:

  client.query('SELECT * FROM "user"', function(err, data) {
    console.log(client, err, data);
  });

works as expected. TIL.