return rows postgresql using node.js and hapi

Question

I run select query using pg ,node.js and hapi, and its work.
but how can i return the rows?

The selected:

 var client = new pg.Client(conString);
        client.connect(function(err,done) {

            if (err) {
                return console.error('could not connect to postgres', err);
            }
        })


function fun(query){
 client.query(query, function (err, result,done) {
                if (err) {
                    console.error('error running query', err);
                    return;
                }
                else{

                    result.rowAsArray=true;
                    console.log(result.rows[0]);
                    data=result.rows;
            }

            });
            return data

        }
}

but its return a object with nothing,
What is the right way?
Thank you.

Kouber Saparev · Accepted Answer · 2014-10-21 13:43:46Z

1

You need to loop through the result set.

function fun(query) {
  var data = [];

  var sql = client.query(query, function(err, result) {
    if (err) {
      console.error('error running query', err);
      return;
    }
  });

  sql.on('row', function(row) {
    console.log(row);
    data.push(row);
  }

  return data;
}

edited Oct 21, 2014 at 13:43

answered Oct 20, 2014 at 16:14

Kouber Saparev

8,2552 gold badges32 silver badges28 bronze badges

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

7 Comments

user3937548 Over a year ago

i get this error: TypeError: Object [object Object] has no method 'on'. what can i do?

Kouber Saparev Over a year ago

I corrected the answer. The on row event handler should have been outside of the query function. But, in fact your approach was good. You should be able to assign data=result.rows and then return data. What is the value of result.rowCount?

user3937548 Over a year ago

The error now is: TypeError: Uncaught error: Object select * from sponsors has no method 'on' where does on() come from?

user3937548 Over a year ago

The value of rowCount is 8

Kouber Saparev Over a year ago

Try now, the name of the variable was conflicting with the name of the function argument - query.

|

Collectives™ on Stack Overflow

return rows postgresql using node.js and hapi

1 Answer 1

7 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

7 Comments

Your Answer

Sign up or log in

Post as a guest

Related