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

20 votes145 views4 answers
Reset auto increment in MySQL
SQL
1 vote142 views4 answers
Mysqldump 1 table only
SQL
2 votes153 views1 answer
Sql OR
SQL
5 votes152 views3 answers
Select tables from mysql database
SQL
1 vote136 views1 answer
DATE_SUB postgres
SQL
0 vote133 views1 answer
Price-colour
SQL
0 vote128 views1 answer
Max length found in mysql
SQL
0 vote110 views1 answer
Jooq finding lastest value in table
SQL
0 vote131 views1 answer
Oracle db timestamp auto add
SQL
1 vote148 views2 answers
Drop table with constraints
SQL