Re: maximum size of psql query file

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: jules(dot)alberts(at)arbodienst-limburg(dot)nl, pgsql-novice(at)postgresql(dot)org
Subject: Re: maximum size of psql query file
Date: 2002-07-24 17:47:51
Message-ID: 200207241047.51387.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice


Jules,

> I'm building a program that will convert out current database (foxpro
> tables with encrypted content) to postgresql. The program will read
> each .DBF file and create SQL statements in a textfile that I can feed
> into postgresql with 'dos2unix; pgsql -f statements.sql'.

Have you considered using COPY instead? You can have your Foxpro script dump
to tab-delimited text files, and a 500mb COPY load is less crash-prone than
500mb of SQL commands.

--
-Josh Berkus
Aglio Database Solutions
San Francisco

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2002-07-24 20:38:30 Re: Killing postgres processes.
Previous Message Josh Berkus 2002-07-24 17:46:08 Re: Security, IP and username restrictions