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 vote178 views2 answers
Sql select inside select
SQL
0 vote216 views1 answer
Error code 1451 sql
SQL
1 vote227 views1 answer
Count of tables in database mysql
SQL
0 vote184 views1 answer
Procedure excute monthly oracle
SQL
1 vote284 views1 answer
Oracle see column type
SQL
1 vote196 views1 answer
How to check the mysql version mac
SQL
15 votes180 views4 answers
Mysql where value is null
SQL
1 vote213 views1 answer
Postgresql not in
SQL
1 vote150 views1 answer
Unique vs distinct sql
SQL
1 vote172 views1 answer
Sql server select rows by distinct column
SQL