title: why nodejs pg with redshift returns only one row all the times?
body: <p>I have a strange issue with the npm-pg library which is returning only one row. but I have more rows in the table when I checked the database table. could someone shed some light?</p>
  
  <pre><code>import pg from 'pg';
  export const sample = async (event, context) =&gt; {
  pg.defaults.ssl = true;
  const client = new pg.Client();
   //console.log(client);
   await client.connect();
    const res = await client.query('SELECT * FROM Sampletable ');
   //console.log(res);
   console.log(JSON.stringify(res.rows));
  return res;
  </code></pre>
  
  <p>result has:
  only one row:<code>[{"XXXX":"YYYY"}]</code></p>