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 vote160 views1 answer
Mysql query with sql to get the next row
SQL
4 votes160 views1 answer
Mysql ip address data type
SQL
19 votes174 views5 answers
Display table in sql
SQL
15 votes150 views1 answer
Mysql int range
SQL
9 votes158 views5 answers
Sql limit
SQL
0 vote157 views1 answer
Get date from timestamp in mysql
SQL
0 vote151 views1 answer
Asp.net core sql server stored procedure
SQL
0 vote157 views1 answer
Postgresql delete limit
SQL
0 vote155 views1 answer
Mysql date only no time
SQL
6 votes158 views3 answers
Commit in sql
SQL