How to make a synchronous query (blocking call) with node-postgres?

node-postgres
Dejan picture Dejan · Apr 3, 2013 · Viewed 12.3k times · Source

While booting my Node.js app, I want to make a couple of synchronous calls to the PostgreSQL database to check some things before continuing the control flow. How can I achieve this using the node-postgres package?

Answer

Johannes Griebenow picture Johannes Griebenow · Oct 26, 2017

You can use the pg-native or pg-sync package.

Related questions

node-postgres: how to execute "WHERE col IN (<dynamic value list>)" query?

I'm trying to execute a query like this: SELECT * FROM table WHERE id IN (1,2,3,4) The problem is that the list of ids I want to filter against is not constant and needs to be different at every execution. I would …

Read More
SSL for PostgreSQL connection nodejs

I am trying to connect to my Heroku PostgreSQL DB and I keep getting an SSL error. Does anyone have an idea on how to enable SSL in the connection string? postgres://user:pass@host:port/database; Been looking for …

Read More
node.js, pg, postgresql and insert queries (app hangs)

I have the following simple node application for data insertion into postgres database: var pg = require('pg'); var dbUrl = 'tcp://user:psw@localhost:5432/test-db'; pg.connect(dbUrl, function(err, client, done) { for (var i = 0; i < 1000; i++) { client.query( 'INSERT …

Read More