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

1 vote257 views1 answer
The input device is not a TTY. If you are using mintty, try prefixing the command with 'winpty'
Shell/Bash
21 votes192 views3 answers
Axios react
Shell/Bash
2 votes252 views1 answer
Linux copy output to clipboard
Shell/Bash
4 votes241 views4 answers
Git copy file from another branch
Shell/Bash
0 vote234 views1 answer
Change directory name lunix
Shell/Bash
0 vote238 views1 answer
Vagrant 16
Shell/Bash
0 vote244 views1 answer
Yum add proxy
Shell/Bash
3 votes236 views2 answers
Vuetify install
Shell/Bash
0 vote254 views1 answer
How to install macos from usb
Shell/Bash
16 votes244 views4 answers
Flutter doctor --android-licenses error
Shell/Bash