Re: Load multiple CSV file in Postgres using COPY

[John R Pierce <pierce@xxxxxxxxxxxx>]

On 2/16/2017 9:43 PM, Magnus Hagander wrote:

Perhaps something like "COPY FROM PROGRAM 'cat /path/*.csv'" would work for you?

he's using HEADER, so cat wouldn't work.    he's also using MSDOS/WIndows style filenames, so cat won't work, anyways..

I'd suggest using something like pgloader, but I don't know if that runs on MS Windows, either.   its very powerful for doing bulk imports from a wide range of formats, and even allows data manipulation.

-- 
john r pierce, recycling bits in santa cruz