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
\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
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:
Old group rules:
You received this message because you are subscribed to the Google Groups
To unsubscribe from this group and stop receiving emails from it, send an email
To post to this group, send email to email@example.com.
To view this discussion on the web visit
For more options, visit https://groups.google.com/d/optout.