pgdevdb

Pgdevdb is a bash script that creates a postgres database and user (with password) from one command. The purpose is to create test postgres users and databases on the fly for quick testing and development. To use it, clone the repo and add pgdevdb.sh to your path.

Usage

Run pgdevdb.sh and the first argument will be the username, user password, and database name.

λ pgdevdb mytestdb

To delete the mytestdb user and database we just created, run it with the -d flag.

λ pgdevdb -d mytestdb

To login directly to the sql shell of mytestdb:

λ pgdevdb -l mytestdb