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 vote95 views1 answer
Sql common columns
SQL
13 votes122 views4 answers
Command line mysql import
SQL
0 vote106 views2 answers
T SQl Checking Your Username
SQL
0 vote107 views1 answer
Create table in dbms cmds
SQL
0 vote115 views1 answer
How to create a new db from dumb file mysql
SQL
0 vote109 views1 answer
Datagrip execute procedure
SQL
8 votes107 views1 answer
Mac restore mysql database command line
SQL
0 vote93 views1 answer
Get records in sql according to month name and count
SQL
0 vote217 views1 answer
Python get backup of sql
SQL
0 vote204 views1 answer
Install mysql on bash
SQL