Create a new user.
CREATE USER defines a new database user account. By default users accounts do not have superuser status. Only a superuser can issue CREATE USER requests.
Enclose the user name in single quotation marks if it contains non-alphanumeric characters. You cannot recreate an existing user. To change the superuser status or password, use ALTER USER.
You need to use the WITH PASSWORD clause when creating a user account for internal authentication. Enclose the password in single quotation marks.
CREATE USER spillman WITH PASSWORD 'Niner27'; CREATE USER akers WITH PASSWORD 'Niner2' SUPERUSER; CREATE USER boone WITH PASSWORD 'Niner75' NOSUPERUSER;
If internal authentication has not been set up, you do not need the WITH PASSWORD clause:
CREATE USER test NOSUPERUSER;