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 vote122 views3 answers
Find below average salary in sql
SQL
20 votes122 views5 answers
Reset auto increment mysql
SQL
0 vote127 views1 answer
Sql combine results from two tables
SQL
3 votes118 views1 answer
Pl sql escape &
SQL
1 vote119 views2 answers
Group_concat limit mysql
SQL
1 vote122 views1 answer
Postgresql round double precision
SQL
0 vote114 views1 answer
SQL Server INSERT INTO SELECT By Complete Examples - NAYCode.com
SQL
0 vote134 views1 answer
How to subquey to do not load in live database in
SQL
0 vote90 views1 answer
Mssql view column data type
SQL
0 vote71 views0 answer
SQL