make temp postgres database
Project description
Installation
$ [sudo] pip install postgres-mktempdb
Scripts usage
command | usage |
---|---|
mktempdb |
usage: mktempdb [OPTION]... |
Examples
$ mktempdb
tmp_LH8LqXy8UGlfMR8zfB3todrc4mwC9Sns
delete temp databases:
$ psql -At -c "SELECT datname FROM pg_database WHERE datname LIKE 'tmp_%'" | xargs -L 1 dropdb
delete temp databases created more than 5 minutes ago:
$ psql -At -c "SELECT datname FROM pg_database
WHERE datname LIKE 'tmp_%' AND (pg_stat_file('base/'||oid||'/PG_VERSION')).modification<now()+interval '5 minutes'" | xargs -L 1 dropdb
Project details
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Close
Hashes for postgres-mktempdb-2019.5.23.tar.gz
Algorithm | Hash digest | |
---|---|---|
SHA256 | 3c24d5b197d1b23c740648260cd1398d8dd4b3221f8f2aac8bef41302c5b6793 |
|
MD5 | 897228dedd62a3eeb5b09640d26036d2 |
|
BLAKE2b-256 | 9f2d464a915373094082e33cbdda7f92971a85d6578baa92d565e522eb9ca3f6 |