# HG changeset patch
# User Oleksandr Gavenko <gavenkoa@gmail.com>
# Date 1571681967 -10800
# Node ID 4339ed4bd568647b6bdbaa08bdb7198a5d3f27a8
# Parent  eede82d482886881fbb939ad0406dbb10cc7ff1b
Check settings.

diff -r eede82d48288 -r 4339ed4bd568 postgres.rst
--- a/postgres.rst	Mon Oct 21 18:23:02 2019 +0300
+++ b/postgres.rst	Mon Oct 21 21:19:27 2019 +0300
@@ -60,6 +60,7 @@
 ::
 
    SELECT name, setting FROM pg_settings;
+   SELECT name, current_setting(name), source FROM pg_settings;
 
 Check extensions
 ================
@@ -497,6 +498,10 @@
 
   $ psql -U $USER -h $HOST -p $PORT  $SCHEMA
 
+Switch to long lines format::
+
+  \x
+
 How to view execution plan::
 
   EXPLAIN query;