Set default schema.
authorOleksandr Gavenko <gavenkoa@gmail.com>
Tue, 24 Mar 2015 17:23:15 +0200
changeset 1703 a85cc266dbdf
parent 1702 d2b977ccbf4f
child 1704 57cb0966464c
Set default schema.
postgre.rst
--- a/postgre.rst	Tue Mar 24 16:54:21 2015 +0200
+++ b/postgre.rst	Tue Mar 24 17:23:15 2015 +0200
@@ -56,6 +56,12 @@
   => SELECT table_schema,table_name FROM information_schema.tables ORDER BY table_schema,table_name;
   => \dt
 
+Set default schema.
+===================
+::
+
+  set search_path to NAME;
+
 Using psql client.
 ==================