Re: Ignore when using COPY FROM

Yes,  I have same problem.  This functionality is "almost" standard,
and
found on other RDBMS.  How do new features get added to the todo list's.
Where can I view the current todo list?

Fredrick

Matthew Kennedy wrote:

> 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.