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

4 votes227 views1 answer
How to move unstaged changes to different branch
Shell/Bash
1 vote249 views1 answer
How to install vim on macos
Shell/Bash
0 vote240 views1 answer
List node running
Shell/Bash
0 vote272 views2 answers
To copy a directory from a local to remote system, use the -r option
Shell/Bash
0 vote251 views1 answer
Record system audio linux terminal
Shell/Bash
2 votes225 views1 answer
Snapd version
Shell/Bash
1 vote227 views1 answer
Github ssh ask for password
Shell/Bash
0 vote229 views1 answer
Pom xml dependency cannot resolve
Shell/Bash
0 vote257 views1 answer
Grep until third match
Shell/Bash
0 vote243 views1 answer
Generate pkcs12 certificate using keytool
Shell/Bash