Modern R Programming Cookbook

Creating a new user in the PostgreSQL database server

In every database server, there should be one database administrator and many user clients. The administrator creates new users and defines roles for each user. Once you have installed the PostgreSQL onto your computer, the super user administrator will have been automatically defined under the postgres username. Now, you can create a new user using the postgres account. In this recipe, you will create a new user and define its role.