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 vote159 views1 answer
Create api project in visual studio 2019 and sql server
SQL
0 vote193 views2 answers
Reseed sql identity
SQL
1 vote253 views1 answer
Mysql connect command
SQL
0 vote186 views1 answer
Get primary key of table
SQL
1 vote211 views1 answer
Mysql search like order by best match
SQL
0 vote179 views2 answers
Update all columns in one update
SQL
2 votes212 views1 answer
Create delete procedure mysql
SQL
0 vote172 views1 answer
Postgresql parse json array
SQL
0 vote202 views1 answer
Import mysql'
SQL
0 vote186 views1 answer
Sql remove last 2 digit
SQL