| From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
|---|---|
| To: | "Milarsky, Jeremy F(dot)" <milarskyj(at)missouri(dot)edu> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Question, re: Running enormous batch file from the command line |
| Date: | 2008-11-02 20:45:09 |
| Message-ID: | 20081102204509.GB32424@svana.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)svana(dot)org> http://svana.org/kleptog/
> Please line up in a tree and maintain the heap invariant while
> boarding. Thank you for flying nlogn airlines.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Raymond O'Donnell | 2008-11-02 21:38:02 | Re: Error in installation... |
| Previous Message | Milarsky, Jeremy F. | 2008-11-02 20:13:34 | Question, re: Running enormous batch file from the command line |