Editing PostgreSQL: CREATE ROLE

* <code>[[CREATE ROLE]]</code> adds a new [[role]] to a [[PostgreSQL]] database [[cluster]]. A role can be considered a [[user]], or [[group]].


==Overview==
* https://www.postgresql.org/docs/14/sql-createrole.html
 CREATE ROLE name [ [ WITH ] option [ ... ] ]
 
 where option can be: 
 
       SUPERUSER | NOSUPERUSER
     | CREATEDB | NOCREATEDB
     | CREATEROLE | NOCREATEROLE
     | CREATEUSER | NOCREATEUSER
     | INHERIT | NOINHERIT
     | LOGIN | [[NOLOGIN]]
     | REPLICATION | NOREPLICATION
     | CONNECTION LIMIT connlimit
     | [ ENCRYPTED | UNENCRYPTED ] PASSWORD 'password'
     | VALID UNTIL 'timestamp'
     | IN ROLE role_name [, ...]
     | IN GROUP role_name [, ...]
     | ROLE role_name [, ...]
     | ADMIN role_name [, ...]
     | USER role_name [, ...]
     | SYSID uid

===Examples===
* <code>CREATE ROLE my_username WITH LOGIN PASSWORD 'jw8s130F4' VALID UNTIL '2022-01-01';</code>
* <code>CREATE ROLE my_username WITH CREATEDB CREATEROLE; </code>
* <code>CREATE ROLE my_username [[NOLOGIN]];</code>

== Related commands ==
* <code>[[ALTER USER]]</code>
* <code>[[CREATE USER]]</code>
* [[PostgreSQL: Database roles]]
* <code>GRANT your_username_origin TO your_new_username_with_same_privileges;</code>
* <code>[[useradd]]</code>
* [[List users]]: <code>[[\du]]</code>

== See also ==
* {{Role}}
* {{SQL}}
* {{PostgreSQL}}

[[Category: PosgreSQL]]
[[Category: SQL]]