Cannot display row count in node.js

Question

I am trying to run the following bit of code in node.js to display the number of tables in a postgresql database:

var pg = require('pg'); 
var conString = "postgres://login:pwd@localhost/DB";
var client = new pg.Client(conString);

client.connect(function(err) {
    if (err) {
        console.error('Could not connect to DB', err);
    } else {
        console.log('Could connect to DB');
        client.query("SELECT * FROM pg_catalog.pg_tables", function(err, result) {
            if (err) {
                console.error('Error with table query', err);
            } else {
                var cnt = result.rows.length;
                console.log("Row count: " + cnt.toString());
            }
        });
        console.log('After query');
        client.end();
    }
});

Unfortunately, only the following is displayed in the console:

Could connect to DB
After query

Why isn't the row count line displayed? How can I find out what the issue is?

C Blanchard · Accepted Answer · 2014-02-01 16:58:34Z

1

Since client.query is asynchronous, client.end() will be called before the query has a chance to return a result

Try moving client.end() inside of your async function to client.query. Then it will only be called after result.rows has been logged to console, like so:

client.connect(function(err) {
    if (err) {
        console.error('Could not connect to DB', err);
    } else {
        console.log('Could connect to DB');
        client.query("SELECT * FROM pg_catalog.pg_tables", function(err, result) {
            if (err) {
                console.error('Error with table query', err);
            } else {
                var cnt = result.rows.length;
                console.log("Row count: " + cnt.toString);
                client.end();
                console.log('After query');
            }
        });
    }
});

answered Feb 1, 2014 at 16:58

C Blanchard

1,0739 silver badges10 bronze badges

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

Collectives™ on Stack Overflow

Cannot display row count in node.js

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related