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 vote387 views1 answer
Cheese not working in ubuntu 20.04 asus
Shell/Bash
11 votes343 views3 answers
Docker tail logs
Shell/Bash
32 votes352 views5 answers
Chocolatey installation
Shell/Bash
0 vote347 views1 answer
Updating Packages in WSL
Shell/Bash
0 vote341 views1 answer
String to date in shell script
Shell/Bash
3 votes350 views2 answers
Install sdkman
Shell/Bash
0 vote367 views1 answer
Days between two dates in Linux
Shell/Bash
0 vote375 views1 answer
Pymongo install windows 10
Shell/Bash
0 vote359 views1 answer
Laravel generate mailable
Shell/Bash
1 vote375 views1 answer
Terminal public ip
Shell/Bash