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

1 vote213 views1 answer
Show per page table in xampp
SQL
5 votes225 views3 answers
MySql get fields of table
SQL
2 votes219 views1 answer
Change primary key sql
SQL
0 vote198 views1 answer
Count column of tables psql
SQL
0 vote223 views1 answer
Mysql dump everythign
SQL
4 votes254 views1 answer
How to drop a database in sql server when it is in use
SQL
0 vote231 views1 answer
Sql server get date of previous sunday
SQL
13 votes212 views2 answers
Check if value is null mysql
SQL
3 votes263 views1 answer
What is having
SQL
0 vote215 views1 answer
Mysql check datetime equals date
SQL