Postgres Pro
Downloads
Home   >   mailing lists

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

From zhong ming wu
Subject Re: How to change the file encoding of a 3gb file?
Date
Msg-id AANLkTilXsTWWB2VDCPLvJpoAXwx3szBZvZhGkY428oo0@mail.gmail.com
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 
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@gmail.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,
>
>

pgsql-general by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: How to change the file encoding of a 3gb file?
Next
From: Craig Ringer
Date:
Subject: Re: xpath index not being used