0

I'm creating a program in Java to read an Excel file, remove some bad rows, create a CSV file from it, and insert it into PostgreSQL database by using COPY syntax. Currently it works if the file and database are in the same machine. I want to make it work if the database is in a remote machine. Is it possible with COPY syntax to grab the CSV file in the other machine to insert it in the database? Or are there another alternatives to do it?

Vivek S.
  • 19,945
  • 7
  • 68
  • 85
Aldibe
  • 1,277
  • 2
  • 11
  • 16

1 Answers1

0

Just connect to the database (with psql) from the server that contains the file and you can just do \copy mytable FROM foo.csv DELIMITER ','.

Kayaman
  • 72,141
  • 5
  • 83
  • 121