Difference between revisions of "Postgres:User Creation"
Jump to navigation
Jump to search
Line 1: | Line 1: | ||
To create a user in Postgres: | To create a user in Postgres: | ||
− | # Log in/su over to the | + | # 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 14:10, 14 November 2016
To create a user in Postgres:
- Log in/su over to the postgres account.
- The basic syntax is createuser username.
- createuser takes some useful switches:
- -D username cannot create databases.
- -d username can create databases.
- -A username cannot create more users.
- -a username can create more users.
- -P prompt for password for username.
- -E encrypt that password.