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 votes195 views6 answers
Mysql delete duplicates
SQL
0 vote216 views2 answers
How to login to mysql as normal user in ubuntu
SQL
0 vote268 views5 answers
Right join
SQL
1 vote192 views1 answer
Copy postgres table from one schema into another
SQL
8 votes241 views1 answer
See all users mysql
SQL
0 vote256 views1 answer
How to find unique element in sql
SQL
0 vote227 views2 answers
Sql if empty then
SQL
0 vote208 views1 answer
Date on SQL
SQL
1 vote211 views1 answer
SQL Integer devision
SQL
0 vote313 views1 answer
Delet all record statment sql
SQL