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

0 vote322 views1 answer
Https://livesql.oracle.com/apex/livesql/s/l8fedwph53gt5gigbacwvu6m0
SQL
1 vote294 views1 answer
Sql auto date
SQL
1 vote262 views1 answer
Oracle boolean to varchar
SQL
4 votes336 views1 answer
Sql delete multiple conditions
SQL
0 vote296 views1 answer
Insufficient memory to excute the sql query
SQL
-1 vote324 views1 answer
Phinehas Psalm 106
SQL
0 vote291 views1 answer
Oracle select invalid views
SQL
0 vote313 views1 answer
Mysql export search results
SQL
2 votes302 views2 answers
Get all columns from table sql
SQL
1 vote306 views1 answer
Postgresql blocked on mac
SQL