Creating a user in PostgreSQL is a simple process. To create a new user, you use the CREATE USER statement.
For example, to create a new user named ‘joe’ with the password ‘secret’, you would run the following statement:
CREATE USER joe WITH PASSWORD ‘secret’;