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 vote219 views1 answer
Vagrant init ubuntu/trusty64
Shell/Bash
0 vote206 views1 answer
Install gcmcore debian 10
Shell/Bash
0 vote202 views1 answer
Add the GitLab package repository
Shell/Bash
-1 vote291 views1 answer
Uninstall redis ubuntu terminal
Shell/Bash
0 vote200 views1 answer
Centos install nslookup
Shell/Bash
1 vote230 views1 answer
Composer tree
Shell/Bash
0 vote229 views1 answer
Git clone into path
Shell/Bash
0 vote203 views1 answer
Powershell read csv file line by line
Shell/Bash
6 votes200 views1 answer
Github add directory to repository
Shell/Bash
0 vote215 views1 answer
MportError: bad magic number in 'npyscreen': b'\x03\xf3\r\n'
Shell/Bash