what is best/right way to call postgres function or stored procedure from nodejs

Question

what is best/right way to call postgres function or stored procedure from nodejs

I am using "pg" module to handle with postgresql db ,what how to call function using pg i have doubt,

I am calling function using query method,

client.query("SELECT * FROM SQSP_IsUserNameExists($1)",[userName], function(err, result) {
  // some code.

});

that is working fine, but is this right way to call postgresql functions.

node.js
postgresql

Answer 1

From the PostgrSQL side, if the function returns a result set than yes the SQL is syntax is correct. As for the Node call syntax I am not familiar with that framework. But if its returning results then I say task complete.

Answer 2

Your code looks correct.

If you want a simpler syntax though, the same example via pg-promise:

db.func('SQSP_IsUserNameExists', userName)
    .then(function (data) {
        console.log(data); // print result data;
    }, function (reason) {
        console.log(reason); // print error;
    });