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 vote119 views1 answer
Mysql select update same table
SQL
0 vote127 views1 answer
R rmysql connect local database Plugin caching_sha2_password could not be loaded
SQL
0 vote122 views1 answer
Column ' ' in field list is ambiguous
SQL
18 votes147 views2 answers
Sql comments
SQL
13 votes120 views2 answers
Sqlite rename column
SQL
0 vote127 views1 answer
What is between keyword used for
SQL
1 vote134 views1 answer
Sql row having max
SQL
3 votes109 views2 answers
Mysql add 2 hours
SQL
0 vote115 views1 answer
C# mysql data reader from two tables
SQL
2 votes124 views1 answer
Express api ith mysql data
SQL