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

2 votes189 views3 answers
Copy data from one table column to another table column in sql
SQL
4 votes193 views2 answers
Mysql delete user if exists
SQL
9 votes178 views3 answers
Show table columns mysql command line
SQL
0 vote180 views1 answer
How to reset table in sql server
SQL
0 vote184 views1 answer
Is there a way to use read_sql_query and the query has WHERE column = Variable?
SQL
0 vote209 views1 answer
Sql server phone constraint
SQL
0 vote186 views1 answer
How to change mysql port in xampp
SQL
3 votes193 views1 answer
Sql insert inserted id
SQL
1 vote196 views1 answer
Group_concat max length mysql
SQL
17 votes167 views6 answers
Sql current date
SQL