Re: Ragged CSV import
От | Andrew Dunstan |
---|---|
Тема | Re: Ragged CSV import |
Дата | |
Msg-id | 4AAA65CB.9070307@dunslane.net обсуждение исходный текст |
Ответ на | Re: Ragged CSV import (Andrew Dunstan <andrew@dunslane.net>) |
Ответы |
Re: Ragged CSV import
|
Список | pgsql-hackers |
I wrote: > I'd love to be able to do something like > > INSERT into foo (x,y,z) select t[3],[t2],[t57] from (COPY RETURNING > t FROM stdin CSV); > > Some IRC discussion suggested ways we could do better than that syntax. I think my current preferred candidate is something like COPY foo (a,b,c) FROM stdin CSV AS t USING (t[3],t[2],[t57]); I'm not sure how we'd could plug a filter into that. Maybe a WHERE clause? My immediate need at least doesn't actually involve filtering anything - we load every line in the CSV into a temp table and then filter what we load into the main tables after applying the business rules. cheers andrew
В списке pgsql-hackers по дате отправления: