diff options
author | bnewbold <bnewbold@robocracy.org> | 2022-06-23 10:35:06 -0700 |
---|---|---|
committer | bnewbold <bnewbold@robocracy.org> | 2022-06-23 10:35:06 -0700 |
commit | c1def3cdf5569c892a75e84b8b23963371f3819d (patch) | |
tree | 225060a76fa55fd8e224c643e4cd7e3d88995505 /software/postgres.page | |
parent | 5be0eb7d31d792366eb1e1be0a6de477a348b723 (diff) | |
parent | 9eff4d99afc1ba861ae32dcd46d88ff6b3ef222f (diff) | |
download | knowledge-c1def3cdf5569c892a75e84b8b23963371f3819d.tar.gz knowledge-c1def3cdf5569c892a75e84b8b23963371f3819d.zip |
Merge branch 'master' of adze:knowledge
Diffstat (limited to 'software/postgres.page')
-rw-r--r-- | software/postgres.page | 17 |
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` + |