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 vote121 views1 answer
Oracle last character of string
SQL
1 vote142 views2 answers
Mysql grant all privileges on *.* to 'root'@' ' identified by
SQL
3 votes221 views4 answers
Sql interview questions
SQL
0 vote123 views1 answer
See Foreign Key
SQL
0 vote128 views1 answer
Sql sort ages
SQL
0 vote127 views1 answer
R dbConnect(odbc::odbc() to ms sql server remote
SQL
0 vote144 views1 answer
Define a variable in mysql from select
SQL
4 votes145 views3 answers
Mysql get column names from table
SQL
1 vote132 views3 answers
Mysql disable foreign keys check
SQL
1 vote131 views1 answer
Oracle sql create or replace view
SQL