Tom Lane wrote:
> Richard Huxton <dev@archonet.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 ...
Which would point to the need to allow "ALTER DATABASE
current_database()" or similar I'd say.
--
Richard Huxton
Archonet Ltd