Postgres:User Creation: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
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 | # 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:
- 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.