Re: Can pg_dump make use of CURRENT/SESSION_USER

<div dir="ltr"><div class="gmail_extra"><br />On Wed, Mar 18, 2015 at 1:24 PM, Robert Haas <<a
href="mailto:robertmhaas@gmail.com">robertmhaas@gmail.com</a>>wrote:<br />><br />> On Tue, Mar 17, 2015 at
1:24PM, Alvaro Herrera<br />> <<a href="mailto:alvherre@2ndquadrant.com">alvherre@2ndquadrant.com</a>>
wrote:<br/>> > If we ever implement something like<br />> ><br />> > COMMENT ON CURRENT_DATABASE IS
...<br/>> ><br />> > it will be useful, because you will be able to restore a dump into<br />> >
anotherdatabase and have the comment apply to the target database.<br /><br /></div><div class="gmail_extra">I think
it'ssimple to implement, but how about pg_dump... we need to add new option (like --use-current-database) or am I
missingsomething ? <br /></div><div class="gmail_extra"><br /><br />> > (Also, I wonder about<br />> >
ALTERUSER foo IN DATABASE current_database ...<br />> > because that will let us dump per-database user options
too.)<br/>><br />> +1 for both of those ideas.<br />><br /><br /></div><div class="gmail_extra">Can you
explainmore about this idea?<br /></div><div class="gmail_extra"><br /></div><div class="gmail_extra">Regards,<br /><br
/></div><divclass="gmail_extra">--<br />Fabrízio de Royes Mello<br />Consultoria/Coaching PostgreSQL<br />>>
Timbira:<a href="http://www.timbira.com.br">http://www.timbira.com.br</a><br />>> Blog: <a
href="http://fabriziomello.github.io">http://fabriziomello.github.io</a><br/>>> Linkedin: <a
href="http://br.linkedin.com/in/fabriziomello">http://br.linkedin.com/in/fabriziomello</a><br/>>> Twitter: <a
href="http://twitter.com/fabriziomello">http://twitter.com/fabriziomello</a><br/>>> Github: <a
href="http://github.com/fabriziomello">http://github.com/fabriziomello</a></div></div>