postgresql ubuntu setup user code example

Example 1: how to create new user and database postgresql in ubuntu

$ sudo -u postgres createuser <username>

Example 2: how to create new user and database postgresql in ubuntu

psql=# grant all privileges on database <dbname> to <username> ;