agora inbox for pgsql-sql@postgresql.org
help / color / mirror / Atom feedFrom: David G Johnston <david.g.johnston@gmail.com>
To: pgsql-sql@postgresql.org
Subject: Re: need to pass the csv file name as value to the column file_id
Date: Wed, 11 Jun 2014 09:03:23 -0700 (PDT)
Message-ID: <1402502603315-5806845.post@n5.nabble.com> (raw)
In-Reply-To: <CAHZ2hW97GiPVx8w+PtePcQyCNo7eGPj5C97AMg1My8g+FoXJtw@mail.gmail.com>
References: <1402480834884-5806798.post@n5.nabble.com>
<1402493925433-5806825.post@n5.nabble.com>
<1402497348563-5806834.post@n5.nabble.com>
<CAHZ2hW97GiPVx8w+PtePcQyCNo7eGPj5C97AMg1My8g+FoXJtw@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-sql>
kranthi wrote
> Actually , we are migrate from vertica to redshift. In redshift we are
> using PostgreSQL. In vertica we used this type I hope it is possible in
> PostgreSQL also
>
> In vertica we used like below. It works fine.
>
> Copy schema.table(
> Xxxxxxxx
> file_id as '2014061123.CSV'
> Xxxxxx
Not that I am aware of or can find documented. Neither in RedShift nor
core.
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-i...
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
view thread (4+ messages)
Message-ID: <1402502603315-5806845.post@n5.nabble.com>
Permalink: ../1402502603315-5806845.post@n5.nabble.com/
Also on: postgresql.org/message-id/1402502603315-5806845.post@n5.nabble.com
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: david.g.johnston@gmail.com
Subject: Re: need to pass the csv file name as value to the column file_id
In-Reply-To: <1402502603315-5806845.post@n5.nabble.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox