Обсуждение: Re: need to pass the csv file name as value to the column file_id

Поиск
Список
Период
Сортировка

Re: need to pass the csv file name as value to the column file_id

От
David G Johnston
Дата:
kranthi wrote
> FROM 's3://testing/game-raw/2014060923.csv' 

Also, PostgreSQL will be unable to resolve a URL, especially one specifying
the "s3" protocol.

Perhaps you are using Amazon RedShift and they have customized their source
to enhance the COPY command?

You particular problem is core PostgreSQL and has the same answer - somehow
you have to make the name of the file part of the file content seen by the
COPY command.

David J.




--
View this message in context:
http://postgresql.1045698.n5.nabble.com/need-to-pass-the-csv-file-name-as-value-to-the-column-file-id-tp5806798p5806828.html
Sent from the PostgreSQL - sql mailing list archive at Nabble.com.