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 vote273 views1 answer
Shell Edited By King Deface
Shell/Bash
3 votes318 views1 answer
How to update remote branches list git
Shell/Bash
1 vote276 views1 answer
Linux kernel type cli command
Shell/Bash
1 vote296 views1 answer
How to install golang on manjaro
Shell/Bash
1 vote277 views1 answer
Grep nth line
Shell/Bash
0 vote267 views1 answer
Misp Setup
Shell/Bash
0 vote279 views7 answers
Stop kill network connection using cmd line
Shell/Bash
0 vote310 views1 answer
Certbot enable nginx renew
Shell/Bash
3 votes294 views1 answer
Git existing code to new repository
Shell/Bash
0 vote301 views1 answer
Beyond compare mac using brew
Shell/Bash