On Thursday 22 January 2009, Vladimir Konrad <vk@xxxxxxxxxxxxx> wrote: > > 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... Yeah it does. iconv buffers everything in memory, as I recall. However, you can "split" the file into manageable pieces, run each through iconv, and recombine afterwards. -- Current Peeve: The mindset that the Internet is some sort of school for novice sysadmins and that everyone -not- doing stupid dangerous things should act like patient teachers with the ones who are. -- Bill Cole, NANAE -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
