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 vote281 views1 answer
How to combine rows in sql server procedure
SQL
2 votes289 views1 answer
Oracle kill session by sql_id
SQL
1 vote262 views1 answer
Sql get all columns from one table but one from another inner join
SQL
-1 vote290 views1 answer
Can pandas fetch data from sql
SQL
0 vote274 views1 answer
Sql server bool select
SQL
0 vote281 views1 answer
Raven ql select count
SQL
0 vote279 views1 answer
Oracle sql drop table
SQL
3 votes294 views2 answers
Sql server current date without time
SQL
1 vote281 views1 answer
Get last week data in mysql
SQL
0 vote260 views1 answer
MySQL error code 2068
SQL