Postgres -- Simple batch file to export CSV

Question

Hi and thanks in advance. I am currently exporting from my postgres database VIA the psql shell with::

    \COPY "Accounts" TO 'C:\Users\admin\Desktop\Accounts.csv' CSV HEADER;

This works fine, but I want to be able to double click a batch file .cmd or .bat that is saved on my desktop to 1) log into the database 2) export the CSV. So that way I dont have to go into psql shell every time. Please help, I did google but postgres resources are few.

When posting here, you will generally get a warm and helpful response so long as you have tried to create the solution first and then post showing where you got stumped. Try updating your post once you have done this. — John Mark Mitchell
– John Mark Mitchell, Commented May 4, 2016 at 23:23
@a_horse_with_no_name I am on a Windows machine with Postgres installed. I do not know the syntax/how to do this. I am new to coding. I want to connect to the database then run that SQL command, just by double clicking one file. i'm assuming its a batch file but I do not know enough. Any help is appreciated. thank you. — Funky Dude
– Funky Dude, Commented May 4, 2016 at 23:24
Ahhh, windows...batch. You tagged this with the tag BASH. That is a scripting language for linux, mac and in rare cases windows. If using Windows you probably want a powershell script. — John Mark Mitchell
– John Mark Mitchell, Commented May 4, 2016 at 23:29

Community · Accepted Answer · 2017-05-23 10:28:08Z

0

Because the comments above are limited in their length and formatting, I am sharing some basic research that might get you started:

edited May 23, 2017 at 10:28

CommunityBot

11 silver badge

answered May 4, 2016 at 23:39

John Mark Mitchell

4,8924 gold badges33 silver badges31 bronze badges

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

Collectives™ on Stack Overflow

Postgres -- Simple batch file to export CSV

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related