Re: Postgresql Copy

On Wed, 31 Oct 2001, Andrew Gould wrote:

> 2. There's a huge fixed width file that I receive
> every quarter. Since the structure is the same, I
> wrote a python script that copies the data to a new
> file, inserting tab delimiters and stripping out the
> extra spaces as it goes. The resulting file is often
> one third the size of the original. I then use copy
> to import the tab delimited data into PostgreSQL.

I've done the same thing using perl. In fact I have actually just
read, parsed, and then inserted the data directly into PostgreSQL.

Cheers,
Rod
--
Let Accuracy Triumph Over Victory

Zetetic Institute
"David's Sling"
Marc Stiegler