diff -r fac6b2db427b -r e538e158c38b postgres.rst
--- a/postgres.rst	Fri Dec 14 12:01:36 2018 +0200
+++ b/postgres.rst	Fri Dec 14 21:33:27 2018 +0200
@@ -64,11 +64,36 @@
   => SELECT table_schema,table_name FROM information_schema.tables ORDER BY table_schema,table_name;
   => \dt
 
+or in all schemas::
+
+  => \dt *.*
+
+List views::
+
+  \dv
+
 List users::
 
   \du
   \du+
 
+List schemas::
+
+  \dn
+
+List indexes::
+
+  \di
+
+List functions::
+
+  \df
+
+List triggers::
+
+  \dy
+
+
 List misc info::
 
   select current_database();
@@ -116,8 +141,8 @@
 
   SELECT relname, relpages FROM pg_class ORDER BY relpages DESC;
 
-Using psql client.
-==================
+Using psql client
+=================
 
 Using password file ``~/.pgpass``::
 
@@ -135,6 +160,10 @@
   EXPLAIN query;
   EXPLAIN ANALYZE query;
 
+Collect statistics::
+
+  ANALYZE table;
+
 How to redirect the output of query to a file::
 
   \o output_file
@@ -145,3 +174,14 @@
   \connect DBNAME
   \c DBNAME
 
+Load external SQL file::
+
+  \i my.sql
+
+Export data
+===========
+
+Export from ``psql``::
+
+  \copy (SELECT * FROM foo) TO '/tmp/my.csv' WITH CSV
+