Export data. Load external SQL file. List schemas/indexes/etc.
--- 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
+