Create a user

To create a user, connect to the database cluster and complete the following steps:

1. At the psql prompt, create the user:

     CREATE USER USER_NAME
         WITH PASSWORD PASSWORD
         ATTRIBUTE1
         ATTRIBUTE2...;
     

   Enter the password when prompted.

   For more information about role attributes, see the PostgreSQL documentation.

2. You can confirm the user creation by displaying the user table:

     SELECT * FROM pg_roles;