| From: | David G Johnston <david(dot)g(dot)johnston(at)gmail(dot)com> |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: need to pass the csv file name as value to the column file_id |
| Date: | 2014-06-11 13:42:27 |
| Message-ID: | 1402494147017-5806828.post@n5.nabble.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David G Johnston | 2014-06-11 14:35:48 | Re: need to pass the csv file name as value to the column file_id |
| Previous Message | David G Johnston | 2014-06-11 13:38:45 | Re: need to pass the csv file name as value to the column file_id |