Useradd postgres

Psql create user

# https://www.postgresql.org/docs/8.0/sql-createuser.html
CREATE USER <username> WITH PASSWORD '<password>' VALID UNTIL '<date here>';

Useradd postgres

sudo -u postgres psqlpostgres=# create database mydb;postgres=# create user myuser with encrypted password 'mypass';postgres=# grant all privileges on database mydb to myuser;

Source: medium.com

Similar codes

3 votes213 views2 answers
Wp do sql query from function
SQL
1 vote188 views1 answer
Wherein mysql
SQL
5 votes166 views1 answer
Mysql select greater than yesterday
SQL
15 votes326 views2 answers
Sql order by alphabetical
SQL
0 vote182 views1 answer
Hex string sql becomes int64
SQL
1 vote165 views1 answer
Postgres check blocking
SQL
0 vote206 views1 answer
Node-pre-gyp ERR! Tried to download(403): https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v3.1.13/node-v72-win32-x64.tar.gz
SQL
3 votes277 views4 answers
Sql interview questions
SQL
11 votes173 views6 answers
Mysql else if
SQL
1 vote184 views1 answer
Postgres left join
SQL