Erik Jones <erik(at)myemma(dot)com> 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