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

From: zhong ming wu <mr(dot)z(dot)m(dot)wu(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: How to change the file encoding of a 3gb file?
Date: 2010-07-19 00:08:13
Message-ID: AANLkTilXsTWWB2VDCPLvJpoAXwx3szBZvZhGkY428oo0@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Will running the following on your file useful

http://www.gnu.org/software/recode/

It helped me with a pg_dump file in the past

On Sun, Jul 18, 2010 at 5:51 PM, Andre Lopes <lopes80andre(at)gmail(dot)com> wrote:
> Hi,
>
> 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.
>
> Best Regards,
>
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Howard Rogers 2010-07-19 00:46:25 Re: Full Text Search ideas
Previous Message Scott Marlowe 2010-07-18 23:40:38 Re: How to change the file encoding of a 3gb file?