Query

incomplete documentation

Not to be created directly from its constructor, the Query is returned from Client#query. It functions primarily as an EventEmitter allowing you to handle returned rows.

• events
  • row
  • end
  • error

Events

## Row

emitted by the query whenever a row is received from the PostgreSQL server upon query execution

## Error

emitted by the query when an error is encountered within the context of query execution.

## End

Emitted by the query when all rows have been returned or when an error has been encountered. In either circumstance, the query's execution is finished and it is no longer interacting with the connection.

todo: have this return the postgresql server status on insert/update/delete etc commands

Prepared statements

I'm still working on the API for prepared statements. Check out the tests for more up to date examples, but what I'm working towards is something like this:

 var client = new Client({
   user: 'brian',
   database: 'test'
 });

 var query = client.query({
   text: 'select * from person where age < $1',
   values: [21]
 });

 query.on('row', function(row) {
   console.log(row);
 });

 query.on('end', function() { client.end() });