Difference between revisions of "PostgreSQL: CREATE USER"

From wikieduonline
Jump to navigation Jump to search
Tags: Mobile web edit, Mobile edit
Tags: Mobile web edit, Mobile edit
Line 15: Line 15:
 
  [[CREATE ROLE]]
 
  [[CREATE ROLE]]
  
* List users: <code>[[\du]]</code>
+
* [[List users]]: <code>[[\du]]</code>
  
 
== Related terms ==
 
== Related terms ==

Revision as of 06:40, 9 September 2021

create user, creates a new user in PostgreSQL

Examples

  • create user your_username

Create a new user:

create user your_username;
Output:
CREATE ROLE

Create a new user and assign a password:

CREATE USER your_username WITH ENCRYPTED PASSWORD 'your_pass';
Output:
CREATE ROLE

Related terms

See also

Advertising: