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. +