Postgres Pro
Downloads
Home   >   mailing lists

Re: How to change the file encoding of a 3gb file? - Mailing list pgsql-general

From manitou-sig@sd-9404.dedibox.fr
Subject Re: How to change the file encoding of a 3gb file?
Date
Msg-id 3427487b-b49d-4967-b5d3-797ecd9fd317@mm
Whole thread Raw
In response to How to change the file encoding of a 3gb file?  (Andre Lopes <lopes80andre@gmail.com>)
List pgsql-general
Tree view 
    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

pgsql-general by date:

Previous
From: Howard Rogers
Date:
Subject: Re: Full Text Search ideas
Next
From: Sergey Konoplev
Date:
Subject: Re: How to change the file encoding of a 3gb file?