schema dumping

Started by Christopher Kings-Lynneover 21 years ago1 messages
#1Christopher Kings-Lynne
chriskl@familyhealth.com.au

Hi,

Can I change pg_dump to never use the AUTHORIZATION clause and use OWNER
TO instead? It would make things a lot simpler, especially in the case
when dumping that the public schema has had its ownership changed.

This is what the comment says:

* Note that ownership is shown in the AUTHORIZATION clause,
* while the archive entry is listed with empty owner (causing
* it to be emitted with SET SESSION AUTHORIZATION DEFAULT).
* This seems the best way of dealing with schemas owned by
* users without CREATE SCHEMA privilege. Further hacking has
* to be applied for --no-owner mode, though!

We now have a better way, but it's non-standard. Shall I change it?

Chris