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.
The views expressed on this blog are those of the author and do not necessarily reflect the opinions of Enteros Inc. This blog may contain links to the content of third-party sites. By providing such links, Enteros Inc. does not adopt, guarantee, approve, or endorse the information, views, or products available on such sites.
Are you interested in writing for Enteros’ Blog? Please send us a pitch!
RELATED POSTS
Revolutionizing Database Management: Enteros UpBeat’s Impact on Organizational Efficiency and Performance
- 2 May 2024
- Software Engineering
In today’s data-driven world, the effective management of databases is paramount for organizational success. Enteros UpBeat stands at the forefront of…
Elevating Database Performance: The Power of Enteros UpBeat in Driving Efficiency and Innovation
Introduction:
In the ever-evolving landscape of database management, organizations require robust solutions to optimize performance and foster innovat…
Empowering Data-Driven Excellence: Enteros UpBeat Revolutionizes Database Management
- 26 April 2024
- Database Performance Management
Enteros UpBeat is a patented database performance management SaaS platform that helps businesses identify and address database scalability and perform…
Revolutionizing Database Management: Enteros UpBeat Leads the Way to Efficiency and Innovation
Enteros UpBeat is a patented database performance management SaaS platform that helps businesses identify and address database scalability and perform…