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 vote314 views1 answer
Jq print array
Shell/Bash
0 vote433 views1 answer
Ssh kali linux command
Shell/Bash
0 vote305 views1 answer
Linux set GUI
Shell/Bash
0 vote316 views2 answers
Kubectl get all the pods
Shell/Bash
2 votes268 views1 answer
How to return to latest version on git
Shell/Bash
15 votes316 views4 answers
Linux export path
Shell/Bash
0 vote344 views1 answer
Base64 decode command line ubuntu
Shell/Bash
0 vote348 views1 answer
Zim files from command prompt
Shell/Bash
0 vote321 views1 answer
Linux external hard drive chmod
Shell/Bash
0 vote352 views1 answer
Dnstwist kali linux
Shell/Bash