Re: TODO item: Allow more complex user/database default GUC settings - Mailing list pgsql-hackers

Tom Lane escribió:

> BTW, have we thought much about the simplest possible solution,
> which is to not have the view?  How badly do we need it?  Seems
> like dropping the functionality into a psql \d command might be
> a viable alternative.

FWIW I came up with a preliminary patch for a new psql command \dus that
shows settings.  It takes a pattern that's used to constrain on roles.
Thus there is no way to view settings for a database.  If there's a need
for that we could use another command, say \dls.

Sample output

alvherre=# \dus fo*
            List of settings
 role | database |       settings
------+----------+-----------------------
 fob  |          | log_duration=true
 foo  | alvherre | work_mem=256MB
                 : statement_timeout=10s
 foo  |          | work_mem=512MB
                 : statement_timeout=1s
(3 rows)


--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support