Postgres:User Creation

From Earlham CS Department
Revision as of 15:10, 14 November 2016 by Bdmarsh13 (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
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.