Check settings.
authorOleksandr Gavenko <gavenkoa@gmail.com>
Mon, 21 Oct 2019 21:19:27 +0300
changeset 2388 4339ed4bd568
parent 2387 eede82d48288
child 2389 6548a372f31f
Check settings.
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;