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

Поиск
Список
Период
Сортировка
От David G Johnston
Тема Re: need to pass the csv file name as value to the column file_id
Дата
Msg-id 1402502603315-5806845.post@n5.nabble.com
обсуждение исходный текст
Ответ на Re: need to pass the csv file name as value to the column file_id  (David G Johnston <david.g.johnston@gmail.com>)
Список 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.

В списке pgsql-sql по дате отправления:

Предыдущее
От: David G Johnston
Дата:
Сообщение: Re: need to pass the csv file name as value to the column file_id
Следующее
От: Andreas Joseph Krogh
Дата:
Сообщение: Problem with duplicate rows when FULL OUTER JOIN'ing 3 derived tables