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

17 votes184 views6 answers
Sql select distinct
SQL
0 vote184 views1 answer
Copy value from one column to another postgres
SQL
1 vote172 views1 answer
Oracle aleter trigger ora-01031
SQL
0 vote186 views2 answers
Select a row include list of array with join two table SQL
SQL
1 vote197 views1 answer
Change table to innodb mysql
SQL
1 vote270 views1 answer
How to select random rows from a table
SQL
1 vote181 views1 answer
Mysql best tutorial for beginners
SQL
1 vote192 views1 answer
How to unlock table in mysql
SQL
1 vote188 views2 answers
T sql get foreign key
SQL
0 vote204 views1 answer
Except in sql
SQL