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
---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
