Postgres Pro
Downloads
Home   >   mailing lists

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 1402502603315-5806845.post@n5.nabble.com
Whole thread Raw
In response to Re: need to pass the csv file name as value to the column file_id  (David G Johnston <david.g.johnston@gmail.com>)
List pgsql-sql
Tree view 
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.

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: Andreas Joseph Krogh
Date:
Subject: Problem with duplicate rows when FULL OUTER JOIN'ing 3 derived tables