This tutorial will show you how to create database in postgres

enter postgres console

psql

create database called ‘database_name‘

CREATE DATABASE database_name;

create user called ‘my_username’ and password is ‘my_password’

CREATE USER my_username WITH PASSWORD 'my_password';

grant all permissions of the new database to the user created

GRANT ALL PRIVILEGES ON DATABASE "database_name" to my_username;

More:

https://www.postgresql.org/community/

if you want latest update and find more tips and tricks to build your own business platform, please checkout more articles on www.productdeploy.com and blog.productdeploy.com