Editing PostgreSQL: CREATE USER

<code>[[create user]]</code>, creates a new user in PostgreSQL
* Official documentation: https://www.postgresql.org/docs/13/sql-createuser.html

== Examples ==
* <code>create user your_username</code>

=== Create a new user ===
 create user your_username;
 Output:
 [[CREATE ROLE]]

=== Create a new user with errors ===
 create user your.username;
 Output:
 ERROR:  syntax error at or near "."

 create user your_username;
 ERROR:  cannot execute [[CREATE ROLE]] in a read-only transaction

=== Create a new user and assign a password ===
 CREATE USER your_username WITH ENCRYPTED PASSWORD 'your_pass';
 Output:
 [[CREATE ROLE]]

 CREATE USER your_username WITH ENCRYPTED PASSWORD 'your_pass';
 Output:
 ERROR:  role "your_username" already exists

 Assign a role with <code>[[GRANT]]</code> command:
 GRANT [[your_defined_role]] TO your_username;
 Output:
 [[GRANT ROLE]]

* [[List users]]: <code>[[\du]]</code>

== Related terms ==
* [[Create database (PostgreSQL)]]
* <code>[[ALTER USER]] YOUR_USER WITH PASSWORD 'your_new_password';</code>
* <code>[[sudo]] -u postgres [[psql]]</code>
* <code>[[GRANT]]</code>
* {{TOC operation databases}}

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


[[Category:PostgreSQL]]
@@ Line 1: / Line 1: @@
 <code>[[create user]]</code>, creates a new user in PostgreSQL
-* Official documentation: https://www.postgresql.org/docs/current/sql-createuser.html
+* Official documentation: https://www.postgresql.org/docs/13/sql-createuser.html
-* <code>[[CREATE]] USER "your_username";</code>
-* <code>CREATE USER your_username WITH ENCRYPTED PASSWORD 'your_pass';</code>
-* <code>CREATE USER username WITH CREATEUSER;</code>
-* <code>CREATE USER username WITH CREATEROLE;</code>
-== Synopsys ==
- CREATE USER name [ [ WITH ] option [ ... ] ]
- where option can be:
-       SUPERUSER | NOSUPERUSER
-     | CREATEDB | NOCREATEDB
-     | CREATEROLE | NOCREATEROLE
-     | INHERIT | NOINHERIT
-     | LOGIN | NOLOGIN
-     | REPLICATION | NOREPLICATION
-     | BYPASSRLS | NOBYPASSRLS
-     | CONNECTION LIMIT connlimit
-     | [ ENCRYPTED ] PASSWORD 'password' | PASSWORD NULL
-     | VALID UNTIL 'timestamp'
-     | [[IN ROLE]] role_name [, ...]
-     | [[IN GROUP]] role_name [, ...]
-     | [[ROLE]] role_name [, ...]
-     | ADMIN role_name [, ...]
-     | USER role_name [, ...]
-     | SYSID uid
 == Examples ==
@@ Line 39: / Line 9: @@
   Output:
   [[CREATE ROLE]]
- create user your_username;
- Output:
- ERROR: [[permission]] denied to create role
 === Create a new user with errors ===
@@ Line 60: / Line 26: @@
   Output:
   ERROR:  role "your_username" already exists
- Solution:
- [[ALTER USER]] user_name WITH PASSWORD 'new_password';
   Assign a role with <code>[[GRANT]]</code> command:
@@ Line 71: / Line 35: @@
 == Related terms ==
-* <code>[[GRANT]]</code>
 * [[Create database (PostgreSQL)]]
 * <code>[[ALTER USER]] YOUR_USER WITH PASSWORD 'your_new_password';</code>
 * <code>[[sudo]] -u postgres [[psql]]</code>
-* <code>[[CREATE]]</code>
+* <code>[[GRANT]]</code>
-* <code>[[SUPERUSER]]</code>
+* {{TOC operation databases}}
-* [[community.postgresql.postgresql_query]]
-* <code>[[community.postgresql.postgresql_privs]]</code>
 == See also ==
-* {{Role}}
+* {{psql}}
-* {{CREATE}}
 * {{SQL}}
+* {{PostgreSQL}}
 [[Category:PostgreSQL]]