Postgres:User Creation: Difference between revisions

From Earlham CS Department
Jump to navigation Jump to search
Skylar (talk | contribs)
No edit summary
 
Bdmarsh13 (talk | contribs)
No edit summary
 
Line 1: Line 1:
To create a user in Postgres:
To create a user in Postgres:


# Log in/su over to the pgsql account.
# Log in/su over to the postgres account.
# The basic syntax is <tt>createuser ''username''</tt>.
# The basic syntax is <tt>createuser ''username''</tt>.
# <tt>createuser</tt> takes some useful switches:
# <tt>createuser</tt> takes some useful switches:

Latest revision as of 19:10, 14 November 2016

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.