I'd prefer it if OWNER TO were only added if it is actually necessary (or there be some option to turn it off). I don't want to edit the entire dump file if I want to restore the database into another SQL database.
There is the existing --no-owner option, which this patch respects, same as old pg_dump.
It's not possible to dump it if necessary, as it's not possible at restore time to know the user they are restoring as I guess.
The old pg_dump would output a session auth, and then wouldn't bother changing it until necessary. However, with ALTER OWNER, I have to dump it for every object, even if it's the same user.
I guess I could optimise so that if the owner matches the superuser specified with the -S option, I wouldn't bother dumping the ALTER?
Chris
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
