Import CSV Files from remote server in postgresql using pgadmin3

734 Views Asked by At

I need the syntax for specifying FILE PATH " to upload CSV files located in the remote server protected by username and password.

I am able to upload the files with the following syntax if the csv files are placed locally .

COPY my_table FROM 'c:\localsystem\file.csv' DELIMITERS ',' CSV;
0

There are 0 best solutions below