Re: Importing Mangled SQL File via psql - Mailing list pgsql-general

From Tom Lane
Subject Re: Importing Mangled SQL File via psql
Date
Msg-id 3649.1251241403@sss.pgh.pa.us
Whole thread Raw
In response to Importing Mangled SQL File via psql  (APseudoUtopia <apseudoutopia@gmail.com>)
List pgsql-general
APseudoUtopia <apseudoutopia@gmail.com> writes:
> The file does contain quite a bit of \r\n's in them for newlines
> inside VARCHAR and TEXT columns, but I thought they would be converted
> into actual newlines as I import it, not the actual character strings
> "\n" and "\r".

If they're inside quoted literals or COPY data, yes; but it looks like
you have one instance that isn't.

            regards, tom lane

pgsql-general by date:

Previous
From: Rob Napier
Date:
Subject: Posting error
Next
From: Lew
Date:
Subject: Re: ETL software and training