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 votes166 views4 answers
Converting mp3 with FFMPEG
Shell/Bash
0 vote169 views1 answer
How to uninstall i7z on ubuntu
Shell/Bash
0 vote166 views1 answer
How to check whether git is initialized or not
Shell/Bash
0 vote162 views1 answer
Powershell equivalent of rm
Shell/Bash
0 vote161 views1 answer
Execution failed for task ':app:compressDebugAssets'.
Shell/Bash
0 vote170 views1 answer
How to check when was the last UBUNTU server patched
Shell/Bash
0 vote164 views1 answer
Minify json python
Shell/Bash
3 votes240 views2 answers
How to install sdkman linux command line
Shell/Bash
0 vote163 views1 answer
How to install powerline for ubuntu
Shell/Bash
0 vote162 views1 answer
Conda command not found linux
Shell/Bash