Postgres:User Creation

From Earlham CS Department
Jump to navigation Jump to search

To create a user in Postgres:

  1. Log in/su over to the postgres account.
  2. The basic syntax is createuser username.
  3. createuser takes some useful switches:
    1. -D username cannot create databases.
    2. -d username can create databases.
    3. -A username cannot create more users.
    4. -a username can create more users.
    5. -P prompt for password for username.
    6. -E encrypt that password.