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 vote291 views1 answer
Multiple row join
SQL
0 vote8.9K views1 answer
Postgresql delete type
SQL
1 vote148 views1 answer
Restart identity postgresql
SQL
8 votes144 views5 answers
Alter table add column with default value
SQL
5 votes132 views2 answers
Create table
SQL
50 votes211 views6 answers
Sql duplicate rows
SQL
0 vote163 views1 answer
Sql alter table order by
SQL
3 votes146 views2 answers
Mysql time
SQL
-1 vote144 views1 answer
Mysql #1064 error
SQL
1 vote105 views1 answer
Flask-sqlalchemy filter_by contains
SQL