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

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.