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 vote216 views2 answers
Mysql calcular idade
SQL
22 votes331 views4 answers
Mysql date format
SQL
0 vote193 views1 answer
Python sql last insertend
SQL
1 vote197 views1 answer
DATE_SUB postgres
SQL
0 vote184 views1 answer
Increment id in mysql
SQL
0 vote204 views1 answer
Drop database using terminal postgres
SQL
1 vote210 views1 answer
Date in where on datetime column clause mysql
SQL
1 vote196 views1 answer
OstgreSQL version
SQL
0 vote188 views1 answer
What are the aggregate function in sql
SQL
0 vote194 views1 answer
Sql gap missing values
SQL