NodeJS PostgreSQL

Question

I have a question, how can I output all rows from postgresql. Now I have some errors. Please help me. Thanks.

This is my code:

'use strict'

const res = client.query("SELECT * FROM public", function(err, rows, fileds) {
const row = [];
for(let i=0; i<rows.length; i++) {
    row = rows[i];
    console.log(row);
}
rows.forEach(async function(row) {
    console.log(row.name);
})
console.log('Finish');
});
const func = ms => new Promise(res => setTimeout(res, ms));
console.dir({func});
console.dir(res);
client.end();

@parladneupane now I changed it. And it shows me { func: [Function: func] } and undefined — Lado
– Lado, Commented Mar 24, 2018 at 15:58

Rafael Araújo · Accepted Answer · 2018-03-25 21:16:57Z

1

As you are not using pool yet, I assume you are using pg older than 6. You should do:

return client.query(sqlStatement)
    .then(res =>
    {
        client.end();

        return res.rows;
    })
    .catch(e =>
    {
        client.end();

        console.error(e);
        throw e;
    });

edited Mar 25, 2018 at 21:16

answered Mar 24, 2018 at 16:08

Rafael Araújo

2011 silver badge8 bronze badges

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

5 Comments

Rafael Araújo Over a year ago

What are you using to connect to postgres and what version?

Lado Over a year ago

Look in PostgreSQL I created database banking and there I have schemas where I have a table account. My version of pg is 7.4.1. So how can I output this table?

Lado Over a year ago

And I don't know why console shows me an error with query.on

Rafael Araújo Over a year ago

Lado I have just changed the code using pg@7 format.

Lado Over a year ago

Cool. Thank you

Collectives™ on Stack Overflow

NodeJS PostgreSQL

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related