node js and postgresql returning undefined

Question

I am trying to select data from my database table and then print it in the console. whenever I try the console returns undefined.

const sql = await pool.query("SELECT * FROM users");
    for(rows in sql){
        console.log(rows.username)
    }

Have you read the documentation? for(rows in sql){ is not how to access the results of the query — Bergi
– Bergi, Commented Jul 7, 2022 at 19:45

ridwan rf · Accepted Answer · 2022-07-08 07:54:06Z

2

To get an array out of pool.query, you need to do the following:

const result = await pool.query("SELECT * FROM users");

const users = result.rows // get an array of users

If you want to get all the username from the users table, you can do:

const usernames = users.map((user) => user.username); // get an array of usernames

answered Jul 8, 2022 at 7:54

ridwan rf

1113 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1