From 04858ed7e251227e70a7105c8197abb194b6195a Mon Sep 17 00:00:00 2001 From: Bryan Newbold Date: Sun, 19 May 2019 22:06:06 -0700 Subject: postgres temp databases --- software/postgres.page | 17 +++++++++++++++++ 1 file changed, 17 insertions(+) (limited to 'software') 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` + -- cgit v1.2.3