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 vote286 views1 answer
Find all files edited after date linux
Shell/Bash
0 vote264 views1 answer
Center dock icons ubuntu
Shell/Bash
0 vote242 views1 answer
Postgre create user
Shell/Bash
0 vote274 views1 answer
Cascadia code vscode ubuntu
Shell/Bash
0 vote265 views1 answer
Add stetho plugin ionic
Shell/Bash
0 vote260 views1 answer
Powershell alternative &&
Shell/Bash
0 vote281 views1 answer
Quasar pug
Shell/Bash
9 votes282 views3 answers
Openssl windows
Shell/Bash
13 votes267 views3 answers
How to install gulp
Shell/Bash
0 vote261 views1 answer
Conky ubuntu 20.04 install
Shell/Bash