Postgres database create

Create postgres database

sudo -u postgres psql
postgres=# create database mydb;
postgres=# create user myuser with encrypted password 'mypass';
postgres=# grant all privileges on database mydb to myuser;

Source: medium.com

Create database postgres

createdb -h localhost -p 5432 -U postgres testdb
password ******

Source: tutorialspoint.com

Similar codes

0 vote324 views1 answer
Create enumerated folders termina
Shell/Bash
0 vote280 views1 answer
How to install jack client in ubuntu
Shell/Bash
1 vote278 views1 answer
Last 2 git log entries
Shell/Bash
1 vote292 views2 answers
Vscode add to gitignore
Shell/Bash
10 votes297 views3 answers
Force delete pod kubernetes
Shell/Bash
8 votes294 views4 answers
How to activate virtual environment using ubuntu
Shell/Bash
0 vote254 views1 answer
Nuget to use npm package
Shell/Bash
1 vote312 views4 answers
Enable ssh on ubuntu 20.04
Shell/Bash
1 vote289 views1 answer
Mysql query result to file
Shell/Bash
0 vote316 views1 answer
Fuser command in ubuntu
Shell/Bash