In this recipe, we will show you two ways of creating a new database user, one with a dedicated command-line utility, and one using SQL commands.
To create new users, you must either be a superuser or have the
From the command line, you can run the
pguser@hvost:~$ createuser bob
If you add the
--interactive command-line option, you activate the interactive mode, which means you will be asked some questions, as follows:
pguser@hvost:~$ createuser --interactive alice Shall the new role be a superuser? (y/n) n Shall the new role be allowed to create databases? (y/n) y Shall the new role be allowed to create more new roles? (y/n) n