PostgreSQL Create User
The PostgreSQL Create User Tool allows users to visually create users for PostgreSQL.
The create user tools prompts the user for the following information:
User Name (The name of the user to create)
Password (The password for the new user)
Password Valid Until (The date to expire the password if applicable)
Store Password Encrypted (Whether or not to store the password in encrypted format)
Allow Create Database (Whether or not the new user can create databases)
Allow Create User (Whether or not the new user can create users)
Group Name (A name of an existing group into which to insert the user as a new member)
Listed below are example SQL statements generated by the Create User Tool for PostgreSQL
CREATE USER testuser WITH PASSWORD 'testpass'
CREATE USER testuser WITH CREATEDB CREATEUSER IN GROUP users ENCRYPTED PASSWORD 'testpass' VALID UNTIL '2019-12-01'