Richard Huxton <dev(at)archonet(dot)com> writes:
> True enough, but I'd think you could make a good argument that dumping a
> database should dump any ALTER commands that are attached to it.
Let's suppose pg_dump did that, so "pg_dump foo >foo.dump" includes
commands like
ALTER DATABASE foo SET ...
Now what happens when you try to load the script in database bar?
Nothing very good ...
regards, tom lane