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 vote233 views1 answer
Update using case in mysql
SQL
23 votes249 views2 answers
Query to delete a database in mysql
SQL
2 votes238 views1 answer
Oracle calculated column
SQL
0 vote195 views1 answer
Kannst du deine finger trainieren
SQL
0 vote234 views2 answers
Oracle create chain rule
SQL
0 vote182 views1 answer
Mysql collation for all languages
SQL
0 vote242 views2 answers
Athena drop partition
SQL
0 vote236 views1 answer
SQL Query to delete all the tables in a database
SQL
17 votes232 views5 answers
Order by sql
SQL
10 votes256 views4 answers
Else if mysql
SQL