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

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 16:03:23
Message-ID: 1402502603315-5806845.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-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-id-tp5806798p5806845.html
Sent from the PostgreSQL - sql mailing list archive at Nabble.com.

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Andreas Joseph Krogh 2014-06-12 09:17:49 Problem with duplicate rows when FULL OUTER JOIN'ing 3 derived tables
Previous 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