Erik Jones <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
