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