How to Execute a Postgres function from NodeJS

Question

I have created a simple nodeJS script and wanted to insert a few records to Postgres DB, how do I execute a Postgres function from NodeJS script.

vitaly-t · Accepted Answer · 2020-03-12 07:37:53Z

2

Using pg-promise, you can try this:

await db.func('funcName', ['arg1','arg2']);

Another way:

await db.any('select * from funcName($1, $2)', [arg1,'arg2']);

And for stored procedures:

await db.proc('procName', ['arg1','arg2']);

See API: func and proc.

vitaly-t

26.1k17 gold badges129 silver badges151 bronze badges

answered Mar 7, 2020 at 7:09

Sandeep Patel

5,1483 gold badges23 silver badges40 bronze badges

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

1 Answer 1