Create A Postgres Database

Creating a postgres database can be done from the command line with:


Old Notes

Connect to the main `postgres` database with a user that has create database privileges via:

(Or, `psql postgres` if your setup for that)


The database is made from a clone of the `template1` database. So, any changes made there will show up in your new database.


You can check what permissions users have with `\du` when logged into the database