Ted Byers <r.ted.byers@xxxxxxxxxx> writes:
> It seems the public schema is
> automagically created by Postgres every time I create
> a new database on a given server, and it has over a
> dozen types, over 400 functions, &c. I don't really
> understand why it needs to be duplicated in every Db
> on a server, but that is another matter.
What it sounds like to me is that you've managed to clutter your
template1 with a lot of stuff you don't actually want, and that's
getting propagated into new databases by CREATE DATABASE. If so,
it's not pg_dump's fault --- you need to clean out template1.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
