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

50 votes408 views4 answers
Sql alter type of column
SQL
7 votes345 views1 answer
Connect mysql docker
SQL
0 vote356 views1 answer
Get db connection detail from sql developer profile
SQL
11 votes325 views2 answers
Having keyword sql
SQL
1 vote363 views1 answer
Regular expression in sql server
SQL
0 vote322 views1 answer
Vbscript create ADODB.Connection
SQL
0 vote342 views1 answer
Tsql generate rows
SQL
13 votes342 views5 answers
Select last row mysql
SQL
2 votes354 views1 answer
Guid to string sql
SQL
0 vote355 views1 answer
Stored function in sql
SQL