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

-4 votes191 views2 answers
Bash not found docker
Shell/Bash
1 vote184 views2 answers
Linux set alternatives /etc/alternatives
Shell/Bash
1 vote188 views1 answer
Linux dark mode
Shell/Bash
181 votes508 views6 answers
Create a new git branch
Shell/Bash
0 vote272 views1 answer
Rhythmbox
Shell/Bash
75 votes209 views6 answers
Npm delete
Shell/Bash
4 votes163 views2 answers
How to clear all the caches in ubuntu
Shell/Bash
12 votes198 views1 answer
Dos dir
Shell/Bash
0 vote233 views1 answer
Merge two branches from different repositories
Shell/Bash
22 votes209 views6 answers
Login to github terminal
Shell/Bash