Re: error-tolerant COPY FROM
| От | Csaba Nagy |
|---|---|
| Тема | Re: error-tolerant COPY FROM |
| Дата | |
| Msg-id | 1107523432.19443.339.camel@localhost.localdomain обсуждение исходный текст |
| Ответ на | Re: error-tolerant COPY FROM ("Joolz" <joolz@arbodienst-limburg.nl>) |
| Ответы |
Re: error-tolerant COPY FROM
|
| Список | pgsql-general |
[snip] > I'm afraid this is a bit too indirect IMHO. As I want to know the > line number in which an error occurs, I would have to traverse the > error-tolerant table with limit 1 offset N, and report N when an > error occurs, hoping that the row order is identical to the line > order in the csv file. So why don't you insert the line number too in the error tolerant table when you do the import ? Then you will have the line number all the time. Not that I would understand what will you do with that line number, once you already have all the data in the table... Cheers, Csaba.
В списке pgsql-general по дате отправления: