Re: problem converting database to UTF-8 - Mailing list pgsql-general

From Vladimir Konrad
Subject Re: problem converting database to UTF-8
Date
Msg-id 20090122204241.4d7ced1c@svr0.h.dearm.co.uk
Whole thread Raw
In response to Re: problem converting database to UTF-8  (David Goodenough <david.goodenough@btconnect.com>)
Responses Re: problem converting database to UTF-8  (Alan Hodgson <ahodgson@simkin.ca>)
Re: problem converting database to UTF-8  (David Goodenough <david.goodenough@btconnect.com>)
List pgsql-general
> iconv does not change the database encodings embedded in the file
> (and it is quite large).

Have you read the manual?

       file   A pathname of an input file. If no file operands are
       specified, or if a file operand is '-', the standard input shall
       be used.


cat the-source-dump.sql | iconv -t utf8 - > my-converted.sql

Size should not matter in this case...

V

pgsql-general by date:

Previous
From: David Goodenough
Date:
Subject: Re: problem converting database to UTF-8
Next
From: Alan Hodgson
Date:
Subject: Re: problem converting database to UTF-8