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

1 vote172 views3 answers
What does git restore do
Shell/Bash
0 vote165 views1 answer
Linux copy files with specific ending
Shell/Bash
1 vote203 views1 answer
Mac unzip
Shell/Bash
0 vote172 views1 answer
Size of folder
Shell/Bash
3 votes165 views2 answers
Ansible create file
Shell/Bash
0 vote162 views6 answers
Push an existing repository from the command line
Shell/Bash
2 votes172 views2 answers
Git clone to existing folder
Shell/Bash
0 vote256 views1 answer
C# tostring 2 digit hex
Shell/Bash
1 vote171 views1 answer
How to push from colab to github
Shell/Bash
-3 votes169 views1 answer
Looking ssh key git
Shell/Bash