Copying postgres query to csv in local dir?

Hello,I am trying to copy a postgres query to either a variable string or a .csv file.I'm 99% there but I can't seem to figure out how to save it.let Client = require('pg').Client let client = new Client ( URL ) // connect to our database client.connect(function (err) { if (err) throw err; // execute a query on our database client.query(`\copy (SELECT "spree_orders".* FROM "spree_orders" WHERE "spree_orders"."completed_at" > current_timestamp - interval '1 day') TO /temp/orders.csv DELIMITER ',' CSV HEADER`, function (err, result) { if (err) throw err; // just print the result to the console console.log(result); // outputs: { name: 'brianc' } // disconnect the client client.end(function (err) { if (err) throw err; }); }); }); I get syntax error at or near "/"How do I fix this?thanks!

Submitted July 06, 2017 at 08:04PM by quesurfin