Execute COPY command in remote database using local file

Question

I'm trying to execute the Postgres COPY command.

COPY warehouse_terminal.test_table FROM 'C:\file.csv' DELIMITERS E'\t'
     CSV HEADER QUOTE E'\"' ESCAPE E'\\' NULL AS '';

The problem is, the db where I'm going to use this is remote, and the file "file.csv" is in my local machine in C:\. As a result, the file is not read.
Remote db, but local file. How can I get this working?

Watters

Answer 1

Use \copy of the psql client on your local machine, it's a wrapper for SQL COPY for just this purpose.

See:

• Problems while importing a txt file into postgres using php

Parlor