Java大量数据插入pgsql,如何将csv数据插入到postgresql数据库（远程数据库）

I have a csv file.

I could insert the data if file and db is available in same server using below command.

psql -h localhost -d local_mydb -U myuser -c "copy mytable (column1, column2) from '/path/to/local/file.csv' with delimiter as ','"

But file is in local server but, db is available in another server (remote)

If i try to do for remote server, using below command

psql -h remotehost -d remote_mydb -U myuser -c "copy mytable (column1, column2) from '/path/to/local/file.csv' with delimiter as ','"

Getting permission denied exception.

How can I do that?

解决方案

\copy (note the backslash) lets you copy to/from remote databases and does not require superuser privileges.

psql -h remotehost -d remote_mydb -U myuser -c "\copy mytable (column1, column2) from '/path/to/local/file.csv' with delimiter as ','"