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 vote154 views1 answer
Mysl like insert a variable
SQL
4 votes120 views2 answers
How to delete row in sql
SQL
0 vote134 views2 answers
MySQL PARTITION BY month automatically
SQL
0 vote112 views1 answer
View acl table oracle
SQL
0 vote128 views1 answer
Rows, INSERT INTO, Returning
SQL
5 votes138 views3 answers
DBMS_OUTPUT.PUT_LINE
SQL
8 votes127 views1 answer
Mysql limit rows
SQL
0 vote123 views1 answer
Add alternate add column sql
SQL
3 votes126 views1 answer
Postgres select max value
SQL
6 votes120 views1 answer
Postgres get size of database
SQL