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 vote196 views1 answer
Execute sql stored procedure in powershell
SQL
15 votes186 views7 answers
MYSQL
SQL
0 vote202 views1 answer
Mysql in clausule string array
SQL
0 vote204 views1 answer
Group by join columns per table
SQL
0 vote201 views1 answer
Mysql order by where condition sub query
SQL
4 votes183 views1 answer
Oracle show errors compilation
SQL
1 vote186 views2 answers
Sql groub by count
SQL
1 vote239 views1 answer
OSError: mysql_config not found
SQL
0 vote190 views1 answer
Sqlserver now
SQL
5 votes242 views1 answer
Oracle ora-00054 find
SQL