add user postgresql ubuntu code example

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

$ sudo -u postgres createuser <username>

Example 2: How do I add a user to a postgres database? cli

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