How to create user and grant permission to user in PostgreSQL
For create database use below in your terminal.
CREATE DATABASE test2;
Not: do not forget semicolon if you do not put semicolon your code will not work.
For create user name and password use below in your terminal.
CREATE USER test2 WITH PASSWORD '123456';
Not: do not forget semicolon if you do not put semicolon your code will not work.
For grant permission to user use below in your terminal.
GRANT ALL ON DATABASE test2 TO test2;