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
Optimizing Budgeting and Cost Allocation in the Finance Sector with Enteros: A Smarter Approach to Financial Efficiency
- 12 November 2024
- Database Performance Management
In the fast-evolving world of finance, where banking and insurance sectors rely on massive data streams for real-time decisions, efficient anomaly man…
Enteros and Cloud FinOps: Unleashing Big Data Potential for eCommerce Profitability
In the fast-evolving world of finance, where banking and insurance sectors rely on massive data streams for real-time decisions, efficient anomaly man…
Strengthening Financial Operations: How Enteros and Cloud FinOps Transform Balance Sheet Management and Root Cause Analysis
- 10 November 2024
- Database Performance Management
In the fast-evolving world of finance, where banking and insurance sectors rely on massive data streams for real-time decisions, efficient anomaly man…
Optimizing Database Management with Enteros: Revolutionizing RevOps, AIOps, and DevOps on Azure
In the fast-evolving world of finance, where banking and insurance sectors rely on massive data streams for real-time decisions, efficient anomaly man…