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

9 votes220 views2 answers
Linux find and delete files with name
Shell/Bash
3 votes189 views2 answers
Update path variable mac
Shell/Bash
22 votes200 views4 answers
Git remove all local changes
Shell/Bash
0 vote189 views1 answer
ModuleNotFoundError: No module named 'slack'
Shell/Bash
0 vote203 views1 answer
Install ag in mac
Shell/Bash
0 vote204 views1 answer
Bash command to open file explorer
Shell/Bash
1 vote224 views1 answer
Add text with terminal
Shell/Bash
0 vote185 views1 answer
Git config global credential cache
Shell/Bash
1 vote259 views2 answers
Convertingwav to mp3 linux ffmpeg
Shell/Bash
3 votes268 views1 answer
Remove empty folders linux
Shell/Bash