How to run a query in postgres-node equal to psql "\copy" command?

Question

I have a shell script that runs a command:

psql -h $DBHOST -U $DBUSERNAME -c "\copy sometable FROM '$PWD/sometable.csv' WITH DELIMITER ',' CSV HEADER"

which works fine.

Now, as I have some requirements to implement more advanced logic, I am migrating some of these commands to nodejs code.

Is it possible to run this \copy command with postgres-node?

If not, I see an alternative to run this command as it is as a shell command from nodejs with require('child_process').spawn.

Vao Tsun · Accepted Answer · 2018-03-12 11:50:44Z

4

you are looking for https://github.com/brianc/node-pg-copy-streams I suppose. It's same authors "extension" to node-pg

answered Mar 12, 2018 at 11:50

Vao Tsun

52.4k13 gold badges114 silver badges149 bronze badges

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

1 Answer 1