Re: Question, re: Running enormous batch file from the command line - Mailing list pgsql-general

From Martijn van Oosterhout
Subject Re: Question, re: Running enormous batch file from the command line
Date
Msg-id 20081102204509.GB32424@svana.org
Whole thread Raw
In response to Question, re: Running enormous batch file from the command line  ("Milarsky, Jeremy F." <milarskyj@missouri.edu>)
List pgsql-general
On Sun, Nov 02, 2008 at 02:13:34PM -0600, Milarsky, Jeremy F. wrote:
> I am attempting to move an unusually large legacy database from old DBF
> files into a Postgres database. I've been able to clean up the DBF
> tables, export them to CSV and convert that CSV into a SQL batch file.

<snip>

At a wild guess it probably thinks that everything between line 2279459
and 3117024 is one line, because you have an uneven number of quotes
and strings can contain a newline. So it thinks the whole lot is one
line.

Fix the quoting and I imagine this problem will also go away.

Have a nice day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> Please line up in a tree and maintain the heap invariant while
> boarding. Thank you for flying nlogn airlines.

Attachment

pgsql-general by date:

Previous
From: "Milarsky, Jeremy F."
Date:
Subject: Question, re: Running enormous batch file from the command line
Next
From: Raymond O'Donnell
Date:
Subject: Re: Error in installation...