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

1 vote142 views2 answers
Postgresql backup and restore globals and data
SQL
0 vote152 views1 answer
Query to remove duplicate rows from a table
SQL
16 votes162 views5 answers
Select last row in sql
SQL
1 vote158 views2 answers
Select only columns that are not empty oracle sql
SQL
0 vote137 views1 answer
Sql server: how to assign value to table variable returned from function
SQL
1 vote170 views1 answer
Sqlalchemy on delete set null
SQL
2 votes134 views1 answer
Oracle kill job by sid
SQL
2 votes181 views1 answer
Select from array in psql
SQL
0 vote156 views1 answer
Java spring boot connect to sql server
SQL
0 vote169 views1 answer
Sql create and grant user access to database
SQL