PostgreSQL CREATE USER statement

Preamble

PostgreSQL CREATE USER statement creates a database account, which allows you to log in to a PostgreSQL database

The syntax for CREATE USER statement in PostgreSQL

CREATE USER user_name
[ WITH [ ENCRYPTED | UNENCRYPTED ] PASSWORD 'password_value'
| VALID UNTIL 'expiration' ];

Parameters and arguments of the statement

• user_name – The name of the database account you want to create.
• password_value – The password to assign user_name.
• expiration – The date/time when the password expires. If you do not want the password to expire, set the expiration value to ‘infinity’.

How to create a user in PostgreSQL using the CREATE USER statement

For example:

CREATE USER trizor;

In this example, the CREATE USER operator will create a new user named trizor. This new user will have no password, but you can use the ALTER USER operator to assign a password later.
If you want to assign a password while creating a user, you can change the CREATE USER statement as follows:

CREATE USER trizor
WITH PASSWORD 'zubastik';

This will create a username trizor with the password zubastik.
If you want to create a trizor user with a zubastik password that expires on January 1, 2020, you must use the CREATE USER operator as follows:

CREATE USER trizor
WITH PASSWORD 'zubastik'
VALID UNTIL 'Jan 1, 2020';

If you want the password for a trizor user never to expire, you must use the CREATE USER operator as follows:

CREATE USER trizor
WITH PASSWORD 'zubastik'
VALID UNTIL 'infinity';

How to create PostgreSQL user and database

About Enteros

Enteros offers a patented database performance management SaaS platform. It proactively identifies root causes of complex business-impacting database scalability and performance issues across a growing number of clouds, RDBMS, NoSQL, and machine learning database platforms.