Postgres:Database Creation

1. Make sure the user that will be using the database is created (Creating a user)
2. Either as the "postgres" user, or as the user that will be using the db, run createdb
   • createdb can be run with no paramenters, in which case a database is created who's name and owner are that of the current user.
   • Syntax is: createdb <Options> dbname description
   • Options:
     1. -D tablespace: Specify default tablespace
     2. -e: Echos the command that createdb generates
     3. -E encoding: Specify character encoding to be used
     4. -O owner: Specify
     5. -q: Do not desplay a response
     6. -T template: Specify template database to use
3. All this and more can be found by typing man createdb at a prompt.

Setting up a simple user DB for classes