On Sun, Oct 30, 2005 at 11:49:41AM -0500, Gregory Maxwell wrote: > On 10/26/05, Christopher Kings-Lynne <[EMAIL PROTECTED]> wrote: > > > iconv -c -f UTF8 -t UTF8 > > recode UTF-8..UTF-8 < dump_in.sql > dump_out.sql > > I've got a file with characters that pg won't accept that recode does > not fix but iconv does. Iconv is fine for my application, so I'm just > posting to the list so that anyone looking for why recode didn't work > for them will find the suggestion to use iconv.
recode did not work for my sample data. It passed through the problem character sequences. I'm still looking for an iconv that doesn't read the entire file into memory. At this point I'm looking to use the split command to process input in 10000 line chunks. Sadly that can't be used in a pipe. BTW, how will sites that use Slony deal with this issue? -- Paul Lindner ||||| | | | | | | | | | [EMAIL PROTECTED]
pgpJXwpPqOFAE.pgp
Description: PGP signature