title: SELECT FROM not working in node js with PG
body: <p>I'm trying to retrieve some information from a Postgree SQL view in a Postgre SQL database. However, the result is always empty. When I execute the same query in the database, it gives me the expected results.</p>
  
  <pre><code>const privq = await db.query('SELECT * FROM user_privilege');
  console.log(privq.rows);
  //[]
  const projectsQuery= await db.query('SELECT * FROM projects');
  console.log(projectsQuery.rows);
  //[{id:1,name:'Example Project',description:'Lorem Ipsum...'},
  //{id:2,name:'Test Proj',description:'testing'}...]
  </code></pre>
  
  <p>It does not happen with other queries. The entity <code>user_privilege</code> is a view and not a table. </p>
  
  <p><strong>UPDATE</strong></p>
  
  <p>I verified the DB and it turns out Datagrip (my program to interact with the DB) was querying the OLD server, while node was querying the new one. The new one actually has no privileges at all, just the projects.</p>