create user in postgresql

CREATE USER my_mate_user WITH PASSWORD 'thisisStrongPassword';
ALTER ROLE my_mate_user SET work_mem = '64MB';
ALTER USER my_mate_user WITH CONNECTION LIMIT 10;

SELECT rolname, rolsuper, rolinherit, rolcreaterole, rolcreatedb, rolcanlogin
FROM pg_roles where rolname ='my_mate_user' ;

          rolname       | rolsuper | rolinherit | rolcreaterole | rolcreatedb | rolcanlogin |    rolconfig
---------------------+----------+------------+---------------+-------------+-------------+-----------------
 my_mate_user | f        | t          | f             | f           | t           | {work_mem=64MB}

(1 row)

\du
       Role name        |                         Attributes                         |     Member of               
------------------------+------------------------------------------------------------+-----------------------------
        my_mate_user    | 10 connections                                             |       {}