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 vote183 views1 answer
Sql column as header
SQL
0 vote173 views1 answer
Alter table add foreign key mariadb example
SQL
2 votes210 views1 answer
Sql server current date minus 5 years
SQL
0 vote183 views1 answer
Create boolean column in MySQL with false as default value?
SQL
0 vote214 views1 answer
How to see the query of a view in mysql
SQL
4 votes188 views2 answers
Sql table
SQL
0 vote197 views1 answer
Soql queries for not contact related account records in salesforce
SQL
6 votes193 views2 answers
Stored procedure to delete data from table in mysql
SQL
0 vote208 views3 answers
Postgres date difference seconds
SQL
0 vote178 views1 answer
How to define a save method in ruby for sql databases
SQL