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 vote123 views1 answer
Close adb shell
Shell/Bash
0 vote125 views1 answer
How to delete files in linxu terminal
Shell/Bash
0 vote113 views1 answer
Flutter pub get taking too long
Shell/Bash
0 vote152 views1 answer
Git overwrite remote files
Shell/Bash
1 vote81 views1 answer
Sync show progress
Shell/Bash
4 votes120 views1 answer
How to reset git branch to a certain commit.
Shell/Bash
1 vote129 views2 answers
Git help
Shell/Bash
0 vote217 views1 answer
Remove spotify for ubuntu
Shell/Bash
0 vote134 views1 answer
Phoenix liveview setup
Shell/Bash
3 votes117 views1 answer
Bash delete env variable
Shell/Bash