Re: need to pass the csv file name as value to the column file_id - Mailing list pgsql-sql

From David G Johnston
Subject Re: need to pass the csv file name as value to the column file_id
Date
Msg-id 1402494147017-5806828.post@n5.nabble.com
Whole thread Raw
List pgsql-sql
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.



pgsql-sql by date:

Previous
From: David G Johnston
Date:
Subject: Re: need to pass the csv file name as value to the column file_id
Next
From: David G Johnston
Date:
Subject: Re: need to pass the csv file name as value to the column file_id