Date: Wed, 11 Jun 2014 06:42:27 -0700 (PDT)
From: David G Johnston <david.g.johnston@gmail.com>
To: pgsql-sql@postgresql.org
Message-ID: <1402494147017-5806828.post@n5.nabble.com>
In-Reply-To: <1402480834884-5806798.post@n5.nabble.com>
References: <1402480834884-5806798.post@n5.nabble.com>
Subject: Re: need to pass the csv file name as value to the column file_id
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Precedence: bulk
Sender: pgsql-sql-owner@postgresql.org

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.


-- 
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql