Re: Query to help in debugging

On Sat, Jan 19, 2013 at 03:29:36PM -0500, Tom Lane wrote:
> Bruce Momjian <bruce@momjian.us> writes:
> >> Tom Lane wrote:
> >>> select name, setting, source from pg_settings
> >>> where source not in ('default', 'override');
> 
> > Here is my very wide output:
> 
> Why are you insisting on cramming version() into this?  It could
> just as easily be a different query.

I am fine with that:
SELECT  version();SELECT  name, current_setting(name), sourceFROM    pg_settingsWHERE   source NOT IN ('default',
'override');

Output:
test=> SELECT  version();
version-------------------------------------------------------------------------------------------------PostgreSQL
9.3develon x86_64-unknown-linux-gnu, compiled by gcc (Debian 4.4.5-8) 4.4.5, 64-bit(1 row)test=> SELECT  name,
current_setting(name),sourcetest-> FROM    pg_settingstest-> WHERE   source NOT IN ('default', 'override');
name           |  current_setting   |
source----------------------------+--------------------+----------------------application_name           | psql
     | client client_encoding            | UTF8               | client DateStyle                  | ISO, MDY
|configuration file default_text_search_config | pg_catalog.english | configuration file lc_messages                |
en_US.UTF-8       | configuration file lc_monetary                | en_US.UTF-8        | configuration file lc_numeric
              | en_US.UTF-8        | configuration file lc_time                    | en_US.UTF-8        | configuration
filelog_timezone               | US/Eastern         | configuration file max_connections            | 100
| configuration file max_stack_depth            | 2MB                | environment variable shared_buffers
|128MB              | configuration file TimeZone                   | US/Eastern         | configuration file(13 rows)
 

--  Bruce Momjian  <bruce@momjian.us>        http://momjian.us EnterpriseDB
http://enterprisedb.com
 + It's impossible for everything to be true. +