summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
-rw-r--r--software/postgres.page17
1 files changed, 17 insertions, 0 deletions
diff --git a/software/postgres.page b/software/postgres.page
index bdb01d8..7d05074 100644
--- a/software/postgres.page
+++ b/software/postgres.page
@@ -15,3 +15,20 @@ Basic status from the psql command line:
\l+ (list databases)
\dt+ (describe table)
+
+## Temporary Databases in Tests
+
+Try `pg_tmp`, though it may not work with high concurrency (due to internal
+postgres locking), and might need special configuration in CI environments.
+
+Debian also ships with `pg_virtualenv` for temporary databases.
+
+---------
+
+More refs/links:
+
+- https://stackoverflow.com/questions/9604723/alternate-output-format-for-psql
+- https://brandur.org/postgres-connections
+- https://www.citusdata.com/blog/2017/07/16/customizing-my-postgres-shell-using-psqlrc/
+- `bind "^R" em-inc-search-prev`
+