Is there a way to use 'COPY' command(PostgreSQL) in windows cli?

Question

Trying to use 'copy' command of PostgreSQL in windows cli command:

COPY myTable FROM value.txt (DELIMITER('|'));

I can't find 'copy' executable file in bin directory.

Can you let me know how can I run 'copy' command in cli?

Added: My windows application is going to use the 'Copy' feature. Need to run it directly from Application.

Thanks in advance.

I could manage to see my required result with following approach.

psql.exe -f copy.sql -p 5433 -U user -s postgres

copy.sql
\copy TARGET_TABLE FROM source.txt (DELIMITER('#'));

It seems that it is for backing up all database? I just need to upload the text file into a table frequently. Thanks. — Sigularity
– Sigularity, Commented Dec 18, 2015 at 4:13
Are you looking to copy an entire table, or to INSERT into a table from a source text file? — Tim Biegeleisen
– Tim Biegeleisen, Commented Dec 18, 2015 at 4:14
There are several lines text in the source text file, and I want to upload those ones into the table. Looks like INSERT. Thanks. — Sigularity
– Sigularity, Commented Dec 18, 2015 at 4:18

Tim Biegeleisen · Accepted Answer · 2015-12-18 04:24:56Z

5

You have the right command (COPY), but you need to begin an interactive session with Postgres if you want use the COPY command from the Windows command line.

psql -U username yourdb

This should leave you at a prompt looking like the following:

yourdb=#

Now you can use the COPY command and it should work:

COPY myTable FROM value.txt (DELIMITER('|'))

The problem you were having is that COPY is not a Windows executable program, it is a Postgres command which is only understood by Postgres.

answered Dec 18, 2015 at 4:24

Tim Biegeleisen

526k32 gold badges323 silver badges399 bronze badges

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

3 Comments

Sigularity Over a year ago

I see. My windows application should use 'copy' feature directly, so I wonder if I can upload text file content without put 'COPY' command in the prompt.

Tim Biegeleisen Over a year ago

You might be able to write a batch script which will begin the Postgres session behind the scenes. The input could be the COPY query you want to run.

Sigularity Over a year ago

I just used a "-f" option to access copy.sql.

Athrey T R · Accepted Answer · 2019-02-01 05:47:12Z

0

For loading Json use the below command- \COPY myTable (data) FROM '~specifypath/data.json';

data is the column where you want to push the json

answered Feb 1, 2019 at 5:47

Athrey T R

631 gold badge3 silver badges11 bronze badges

Collectives™ on Stack Overflow

Is there a way to use 'COPY' command(PostgreSQL) in windows cli?

2 Answers 2

3 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related