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 vote434 views1 answer
Brew service start redis
Shell/Bash
0 vote346 views1 answer
Install rollup locally
Shell/Bash
0 vote311 views1 answer
Recursively delete node_modules
Shell/Bash
0 vote340 views1 answer
Linux yaml validator command line
Shell/Bash
1 vote341 views1 answer
Linux start simple http server
Shell/Bash
0 vote325 views1 answer
Install winrt
Shell/Bash
50 votes384 views1 answer
Ubuntu version command line
Shell/Bash
15 votes361 views3 answers
Node install specific version
Shell/Bash
0 vote361 views1 answer
Grep simon
Shell/Bash
2 votes410 views1 answer
Nginx post size
Shell/Bash