Erik Jones <erik@xxxxxxxxxx> writes: > Lou Duchez wrote: >> 2) "pg_dumpall -E". If I could specify a single encoding for all my >> database dumps, I could use pg_dumpall. > I guess you missed this: > http://www.postgresql.org/docs/8.2/interactive/sql-grant.html Also, on the second point, you can do export PGCLIENTENCODING=whatever before running pg_dumpall. A -E switch might be more obvious but it's not like you can't do it now. regards, tom lane
