On Thu, Jul 01, 2010 at 09:31:12AM -0700, Mike Christensen wrote: > Then, I edited the file in Notepad and saved it as UTF8 which also > appears to have worked. I don't think you want to be doing this. The file should contain a "set client_encoding" of the correct value which will let PG to do the "right thing" when you import it back into a UTF8 database. -- Sam http://samason.me.uk/ -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general