I swap between databases all the time for various projects, and end up Googling and how to do the initial setup all the time, so the purpose of this document is to list a set of commands that anyone would end up using in getting started.
The simplest way to do this, without calling the psql
utility and calling the CREATE ROLE
and
a bunch of other SQL Statements is to use the createuser
utility.