gistfile1.js

// CONFIG PACKAGES
 
var express = require('express');
var app = express.createServer();
var socket = require('socket.io');
var pg      = require('pg');
 
app.configure(function(){
  app.use(express.static(__dirname + '/'));
});
// CONFIG PORT
var server  = app.listen(3000);
// CONFIG LISTEN
var io      = socket.listen(server);
 
//CONFIG DB

var client = new pg.Client(conString);
client.connect();
var clients = [];
io.sockets.on('connection', function(socket) {
    socket.on('send_message', function(data_senha) {
var sql = 'SELECT contador, id_uni, id_serv, num_senha, sig_senha, msg_senha, nm_local, num_guiche, status FROM painel_senha WHERE status = 0 ORDER BY contador DESC ';
      var query = client.query(sql);
      console.log(" *** INICIANDO ... *** ");
      client.query(sql, function(err, result) {
          console.log("Row count: %d",result.rows.length);
        
        for (var i=0; i<result.rows.length; i++){
 
          setTimeout(function(){
              var row = result.rows[i];
              data_senha.message = row;
 
              socket.broadcast.emit('get_message_senha', data_senha);
              console.log(" ::: "+row.sig_senha+" ::: "+row.num_senha+" ::: "+row.nm_local+" ::: "+row.num_guiche+" :::");
 
          }, 1000);
        }
console.log(" *** FIM *** ");
      
    });
});