PostgreSQL: CREATE USER

From wikieduonline
Jump to navigation Jump to search

Examples

  • create user your_username

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 a new user and assign a password:

CREATE USER your_username WITH ENCRYPTED PASSWORD 'your_pass';
Output:
CREATE ROLE
Assign a role with GRANT command:
GRANT your_defined_role TO your_username;

Related terms

See also

Advertising: