Ignore when using COPY FROM

Поиск
Список
Период
Сортировка
От mkennedy@hssinc.com (Matthew Kennedy)
Тема Ignore when using COPY FROM
Дата
Msg-id 39ABC56B.1A3F7F6A@opushealthcare.com
обсуждение исходный текст
Список pgsql-general
I have a ton of data in a text delimited file from an old legacy system.
When uploading it into postgres, I'd do something like this:

    COPY stuff FROM 'stuff.txt' USING DELIMITERS = '|';

The problem is some of the rows in stuff.txt may not conform to the
stuff table attributes (duplicate keys, for example). The command above
terminates with no change to the table stuff when it encounters an error
in stuff.txt. Is there a way to have postgres ignore erroneous fields
but keep information about which fields weren't processed. I believe
Oracle has some support for this through an IGNORE clause.

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

Предыдущее
От: The Hermit Hacker
Дата:
Сообщение: Re: 7.1 Release Date
Следующее
От: teg@redhat.com (Trond Eivind Glomsrød)
Дата:
Сообщение: Re: 7.1 Release Date