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

2 votes136 views1 answer
Center table markdown github
Shell/Bash
1 vote136 views1 answer
Ls show octal permissions
Shell/Bash
1 vote143 views1 answer
The current branch zuqing_feature2 has no upstream branch.
Shell/Bash
20 votes124 views6 answers
How to push repository to github
Shell/Bash
4 votes145 views2 answers
Npm find peer dependencies
Shell/Bash
3 votes139 views3 answers
Oh my zsh git
Shell/Bash
-1 vote132 views2 answers
Git clone with branch name command
Shell/Bash
0 vote136 views1 answer
How-to-remove-show-applications-icon-from-the-dock-in-ubuntu-20-04
Shell/Bash
1 vote150 views1 answer
Ionic 4 install bootstrap
Shell/Bash
9 votes147 views9 answers
Material ui
Shell/Bash