Postgres:User Creation
Jump to navigation
Jump to search
To create a user in Postgres:
- Log in/su over to the pgsql 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.