Postgres Pro
Downloads
Home   >   mailing lists

Re: Can pg_dump make use of CURRENT/SESSION_USER - Mailing list pgsql-hackers

From Robert Haas
Subject Re: Can pg_dump make use of CURRENT/SESSION_USER
Date
Msg-id CA+TgmoZzLOgGX9ryGC+LLOOO3XVkVACSk-Ywpo+_YzCgDf6bvA@mail.gmail.com
Whole thread Raw
In response to Re: Can pg_dump make use of CURRENT/SESSION_USER  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Responses Re: Can pg_dump make use of CURRENT/SESSION_USER  (Fabrízio de Royes Mello <fabriziomello@gmail.com>)
List pgsql-hackers
Tree view 
On Tue, Mar 17, 2015 at 1:24 PM, Alvaro Herrera
<alvherre@2ndquadrant.com> wrote:
> If we ever implement something like
>
> COMMENT ON CURRENT_DATABASE IS ...
>
> it will be useful, because you will be able to restore a dump into
> another database and have the comment apply to the target database.
> (Also, I wonder about
> ALTER USER foo IN DATABASE current_database ...
> because that will let us dump per-database user options too.)

+1 for both of those ideas.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: INSERT ... ON CONFLICT IGNORE (and UPDATE) 3.0
Next
From: Grzegorz Parka
Date:
Subject: Re: GSoC idea - Simulated annealing to search for query plans