Hi I have found two ways for export postgresql to csv using below two commands in windows command terminal: 1) it is to export into remote machine where postgres is running copy (SELECT firstname, lastname FROM emps ORDER BY lastname, firstname) TO 'E:/file_test' CSV HEADER 2) it is to export into local machine from where we try to connect remote machine \copy (SELECT firstname, lastname FROM emps ORDER BY lastname, firstname) TO 'E:/file9' CSV HEADER
In node js second command (i.e \copy) is not working using node 'pg' npm package. Is there any way to use \copy in node js ? please let me know as soon as possible....... -- Job board: http://jobs.nodejs.org/ New group rules: https://gist.github.com/othiym23/9886289#file-moderation-policy-md Old group rules: https://github.com/joyent/node/wiki/Mailing-List-Posting-Guidelines --- You received this message because you are subscribed to the Google Groups "nodejs" group. To unsubscribe from this group and stop receiving emails from it, send an email to nodejs+unsubscr...@googlegroups.com. To post to this group, send email to nodejs@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/nodejs/54473b31-6356-4b8a-8e26-17fd15cf9949%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.