CREATE USER statement
This PostgreSQL tutorial explains how to use the PostgreSQL CREATE USER statement with syntax and examples.
Description
The CREATE USER statement creates a database account that allows you to log into the PostgreSQL database.
Syntax
The syntax for the CREATE USER statement in PostgreSQL is:
CREATE USER user_name
[ WITH [ ENCRYPTED | UNENCRYPTED ] PASSWORD 'password_value'
| VALID UNTIL 'expiration' ];
Parameters or Arguments
user_name
The name of the database account that you wish to create.
password_value
The password to assign to user_name.
expiration
The date/time value when the password will expire. If you never want the password to expire, you set expiration to 'infinity'.
Example
Let's look at how to create a user in PostgreSQL using the CREATE USER statement.
For example:
CREATE USER fastread.aitechtonic;
In this example, the CREATE USER statement would create a new user called fastread.aitechtonic. This new user would not have a password, but you could use the ALTER USER statement to assign a password later.
If you wanted to assign a password at the time that the user is created, you could change the CREATE USER statement as follows:
CREATE USER fastread.aitechtonic
WITH PASSWORD 'fantastic';
This would create a user called fastread.aitechtonic with a password of 'fantastic'.
If you wanted to create the user fastread.aitechtonic with a password of 'fantastic' that expires on January 1, 2015, you would use the CREATE USER statement as follows:
CREATE USER fastread.aitechtonic
WITH PASSWORD 'fantastic'
VALID UNTIL 'Jan 1, 2015';
If you wanted the password for the user fastread.aitechtonic to never expire, you would use the CREATE USER statement as follows:
CREATE USER fastread.aitechtonic
WITH PASSWORD 'fantastic'
VALID UNTIL 'infinity';