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.
alvherre=# \dus fo*
List of settings
role | database | settings
fob | | log_duration=true
foo | alvherre | work_mem=256MB
foo | | work_mem=512MB
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
In response to
pgsql-hackers by date
|Next:||From: Tom Lane||Date: 2009-09-30 20:05:47|
|Subject: Re: TODO item: Allow more complex user/database default GUC settings |
|Previous:||From: Tom Lane||Date: 2009-09-30 19:52:29|
|Subject: Re: latest hstore patch |