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 vote125 views1 answer
Vim select lines and delete
Shell/Bash
0 vote131 views1 answer
Git find which files and folders are currently in the index
Shell/Bash
0 vote133 views1 answer
[INS-30131] Initial setup required for the execution of installer validations failed.
Shell/Bash
22 votes148 views3 answers
Artisan migration rollback
Shell/Bash
99 votes130 views3 answers
How to install cv2 using pip
Shell/Bash
1 vote124 views1 answer
Install teams manjaro
Shell/Bash
0 vote130 views1 answer
Crear repo para git hub
Shell/Bash
13 votes155 views6 answers
Docker on linux
Shell/Bash
0 vote121 views1 answer
Nvcc issue in jetson nano
Shell/Bash
1 vote134 views1 answer
How to delete a commit in git remotely
Shell/Bash