PostgreSQL: CREATE USER

From wikieduonline
Revision as of 06:40, 9 September 2021 by Welcome (talk | contribs) (→‎Examples)
Jump to navigation Jump to search

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: