How to copy a csv file from a url to Postgresql

Question

Is there any way to use copy command for batch data import and read data from a url. For example, copy command has a syntax like :

COPY sample_table
FROM 'C:\tmp\sample_data.csv' DELIMITER ',' CSV HEADER;

What I want is not to give a local path but a url. Is there any way?

Answer 1

It's pretty straightforward, provided you have an appropriate command-line tool available:

COPY sample_table FROM PROGRAM 'curl "http://www.example.com/file.csv"'

Since you appear to be on Windows, I think you'll need to install curl or wget yourself. There is an example using wget on Windows here which may be useful.