> Actually, KL, that would solve a lot of these duplicate object problems. What
> if pg_restore used Template0 and not Template1? It wouldn't fix the "drop
> public schema" issue but it would solve the others.
Not sure what you mean here, but CVS pg_dump dumps like this:
CREATE DATABASE phppgadmin WITH TEMPLATE = template0 OWNER = chriskl
ENCODING = 'LATIN1';
CREATE DATABASE usa WITH TEMPLATE = template0 OWNER = usadmin ENCODING =
'LATIN1';
Chris