Re: Import German Decimal Numbers

From: Tino Wildenhain <tino(at)wildenhain(dot)de>
To: Thomas Pundt <thomas(dot)pundt(at)rp-online(dot)de>
Cc: pgsql-general(at)postgresql(dot)org, Jan Christian Dittmer <jcdittmer(at)web(dot)de>
Subject: Re: Import German Decimal Numbers
Date: 2008-05-07 13:57:25
Message-ID: 4821B545.10901@wildenhain.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Thomas Pundt wrote:
> On Mittwoch, 7. Mai 2008, Jan Christian Dittmer wrote:
> | The (current) file is 1.4 GB so it will take ages to let awk chew on it
> | I guess.
>
> If you think awk is a bottleneck, I'd recommend using perl instead. It's waaay
> faster and should process your file within minutes if not faster.
>
isnt perl just another frontend for awk? ;)) SCNR ;)

There is also http://pgfoundry.org/projects/pgloader/
and if not already implemented it should be fairly
easy to implement a data filter within this one.

Cheers
Tino

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael Enke 2008-05-07 13:58:34 pg_dumpall: pg_conversion table not saved
Previous Message Thomas Pundt 2008-05-07 13:48:21 Re: Import German Decimal Numbers