Re: Using COPY

Joseph Koenig <joe@jwebmedia.com> writes:
> We're converting a db from Access to PostgreSQL for a client - I need to
> export all of his data into postgres on Linux - I'm trying to use the
> COPY command, however, his comment fields have line breaks in them which
> causes the copy to throw a parse error at that line. I'm sure others
> have run into this - is there an easy way to avoid this? Thanks,

You'll need to transform the linebreaks that should be data into \n
(backslash-n) or \LF (backslash-newline) sequences.

            regards, tom lane