Building RESTful Web services with Go

Adding users and databases in PostgreSQL

Now, we should know how to create a new user and database. For this, we are going to use Ubuntu/Mac as the general example. We do this in a shell called the psql shell. We can see all available commands in psql using the \?  command. In order to enter into psql, first change to the postgres user. On Ubuntu, you can do that using the following command:

sudo su postgres

Now, it turns us into a user called postgres. Then, launch the psql shell using the psql command. If you type \? in there, you see the output of all available commands:

 

To list all available users and their privileges, you will find a ...