postgre.rst
changeset 1703 a85cc266dbdf
parent 1702 d2b977ccbf4f
child 1708 f1924a82b246
--- 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.
 ==================