Correct way of calling a postgres function using node-postgres

Question

I am trying to workout how to call a postgres function using node-postgres but unfortunately cannot find any examples.

I am seeing examples on the web like this but this is based off a different package (pg-promise), which I am not using:

db.func('inserttask', ['task_name','task_type'])

I am also seeing examples like this as well:

const query= `SELECT inserttask($1, $2)`;        
result= await pool.query(query, ['task_name','task_type']);

I haven't as yet tried these as I wanted to check which approach is correct, when using node-postgres.

yeya · Accepted Answer · 2021-06-09 08:30:53Z

1

From the link you provided:

const res = await client.query('SELECT $1::text as message', ['Hello world!'])

Isn't it good enough?

If you have official docs that answer your question, it is usually the one to trust.

answered Jun 9, 2021 at 8:30

yeya

2,2791 gold badge26 silver badges40 bronze badges

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

2 Comments

Is this actually for a function call?

I don't think there is any difference, just try.