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 votes282 views1 answer
Start mysql server by terminal in linux
SQL
13 votes272 views3 answers
Sql select from multiple tables without join
SQL
0 vote267 views2 answers
Select index table oracle
SQL
16 votes288 views6 answers
Python sqlite
SQL
0 vote308 views1 answer
Mysql create index lost connection
SQL
0 vote270 views1 answer
Rename view mysql
SQL
1 vote295 views1 answer
Mysql select row max date
SQL
11 votes253 views2 answers
Sql rank
SQL
0 vote299 views1 answer
How to get button for every record from mysql
SQL
0 vote288 views1 answer
Nvl2 syntax
SQL