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 vote300 views1 answer
Delete * from where id = 1;
SQL
-1 vote290 views1 answer
How to create foreign key in sql server management studio
SQL
0 vote297 views1 answer
Set a value by excuting stored procedure
SQL
14 votes324 views3 answers
How to add default constraint in mysql
SQL
20 votes292 views4 answers
Sqlite create table if not exists
SQL
0 vote340 views1 answer
Sql trim whitespace
SQL
0 vote277 views1 answer
Pl sql turn off variable substitution
SQL
0 vote310 views1 answer
How to create a table based on another table in mysql
SQL
0 vote293 views2 answers
Csv into data postgres
SQL
12 votes280 views1 answer
Create column sql server
SQL