How do you run code on a remote postgres database on heroku from .bat file

Question

If I remote into a postgres database on heroku with heroku pg:psql -a appname I can wait a few seconds for it to connect, then run \copy (SELECT * FROM users) TO users.csv CSV DELIMITER ',' HEADER to extract a table from the remote database to my desktop.

However, if I put these two lines of code into a .bat file and run it, it opens cmd.exe and connects to the postgres database (as expected), but then nothing happens (no more code is executed)

How do you construct the .bat file so that it runs the first line (to connect to the remote database), then executes the subsequent lines inside the remotely connected database?

Eelke · Accepted Answer · 2018-08-03 12:59:29Z

1

You would have to pass the command to psql with the -c switch.

psql -c "\copy (SELECT * FROM users) TO users.csv CSV DELIMITER ',' HEADER"

If you need to execute more commands it will be easier to put them in a seperate file and pass that to psql with the -f switch.

answered Aug 3, 2018 at 12:59

Eelke

22.3k5 gold badges57 silver badges77 bronze badges

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

Collectives™ on Stack Overflow

How do you run code on a remote postgres database on heroku from .bat file

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related