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 votes185 views1 answer
Force using index plsql
SQL
2 votes230 views1 answer
Select a certain number of entries from select mysql
SQL
0 vote229 views1 answer
Mysql remove last character
SQL
3 votes171 views1 answer
Mssql remove column
SQL
4 votes184 views3 answers
Count with where
SQL
2 votes242 views1 answer
Get the mysql table columns data type mysql
SQL
3 votes194 views1 answer
What is having
SQL
1 vote169 views1 answer
Postgres check for foreign key
SQL
1 vote174 views1 answer
Sql server datetime vs datetime2
SQL
3 votes204 views3 answers
Docker create postgresql database
SQL