How PostgreSQL Copy command work on Windows?

Question

I need to copy table data into text file on Windows in csv format. How to do that?

What I have tried:

COPY test TO '"E:\\test.csv"' DELIMITER ',' CSV HEADER;

I am receiving an error while executing this query. That test.csv file have to create first before copying data into that.

ERROR: relative path not allowed for COPY to file SQL state: 42602

You have both single and double quotes around your file path. Try removing the double quotes. — Nick Barnes
– Nick Barnes, Commented Sep 19, 2018 at 15:34
If it is remote server running on *nix OS then absolute Win path interpreted as relative on it. — Abelisto
– Abelisto, Commented Sep 19, 2018 at 15:39

Slumdog · Accepted Answer · 2018-09-19 21:08:24Z

2

This will work providing you have permissions. It will put the csv file at the root directory of the same drive that Postgresql is installed on, probably C:

COPY test TO '\test.csv' DELIMITER ',' CSV HEADER;

answered Sep 19, 2018 at 21:08

Slumdog

4702 silver badges5 bronze badges

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

Collectives™ on Stack Overflow

How PostgreSQL Copy command work on Windows?

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