Console

$ psql #logs in to default database & default user
$ sudo -u <rolename:postgres> psql #logs in with a particular user

Replace anything within <placeholder> accordingly

Commands

Creating database

 $ createdb databasename
0 Comments for this cheatsheet. Write yours!