Difference between revisions of "Postgres:User Creation"
Jump to navigation
Jump to search
(No difference)
|
Revision as of 20:51, 23 February 2005
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.