Re: How to change the file encoding of a 3gb file?

From: manitou-sig(at)sd-9404(dot)dedibox(dot)fr
To: "Andre Lopes" <lopes80andre(at)gmail(dot)com>
Cc: "postgresql Forums" <pgsql-general(at)postgresql(dot)org>
Subject: Re: How to change the file encoding of a 3gb file?
Date: 2010-07-18 23:35:24
Message-ID: 3427487b-b49d-4967-b5d3-797ecd9fd317@mm
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Andre Lopes wrote:

> I'am trying to import an SQL file with 3gb of INSERTS. I must to change the
> encode of the file to UTF8, how can I change the encode of the file without
> open it? This 3gb file crashes every program...
>
> Give me a clue.

I'd use recode: http://recode.progiciels-bpi.ca/index.html
It can recode large files without needing much memory.

Best regards,
--
Daniel
PostgreSQL-powered mail user agent and storage: http://www.manitou-mail.org

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2010-07-18 23:40:38 Re: How to change the file encoding of a 3gb file?
Previous Message Rory Campbell-Lange 2010-07-18 22:38:46 Re: How to import *.sql file to postgresql database