5

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?

Erwin Brandstetter
  • 605,456
  • 145
  • 1,078
  • 1,228
muffin
  • 2,034
  • 10
  • 43
  • 79

1 Answers1

10

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

See:

Erwin Brandstetter
  • 605,456
  • 145
  • 1,078
  • 1,228