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

10 votes341 views1 answer
Oracle dependencies table
SQL
1 vote327 views1 answer
Adding a check statement in sql
SQL
7 votes317 views1 answer
Sql management studio display line numbers
SQL
8 votes302 views2 answers
Alter column name in mssql
SQL
0 vote316 views1 answer
Postgresql update to unique
SQL
0 vote331 views1 answer
Postgresql comandos basicos
SQL
0 vote335 views1 answer
Select from column mysql
SQL
1 vote327 views1 answer
Sql select contem uma palavra
SQL
0 vote320 views1 answer
Sql server split string and insert into table select
SQL
0 vote319 views1 answer
Uuid sqlalcomany
SQL