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

3 votes144 views2 answers
Df to sql pandas sql achemy
SQL
3 votes129 views2 answers
Laravel tosql with bindings
SQL
0 vote130 views1 answer
Http://challenge01.root-me.org:58036/wsasd
SQL
3 votes137 views1 answer
Mysql insert on dupèlicate
SQL
0 vote101 views1 answer
Mariadb list tables
SQL
0 vote142 views1 answer
Mysql trim characters
SQL
0 vote131 views1 answer
Sql insert tuple
SQL
0 vote145 views4 answers
Change schema in sql server
SQL
9 votes284 views2 answers
Current date in postgresql minus 1 day
SQL
1 vote134 views3 answers
Get all tables postgres
SQL