zach cruise <zachc1980@xxxxxxxxx> writes: > Thanks! I just created new database using old database as template, > and everything got copied over without errors. is that recommended > over pg_dump though when just recreating database for different > encoding? It's pretty much guaranteed not to work, since the data will just be copied without any encoding conversion. You could possibly get away with it if the database is empty of data. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general