/Shell/Bash/Create postgres user windows

Create postgres user windows

Create db user postgres

sudo -u postgres psql
postgres=# create database mydb;
postgres=# create user myuser with encrypted password 'mypass';
postgres=# grant all privileges on database mydb to myuser;

Source: medium.com

Psql create user

# https://www.postgresql.org/docs/8.0/sql-createuser.html
CREATE USER <username> WITH PASSWORD '<password>' VALID UNTIL '<date here>';

Create new user in postgres

CREATE USER visualscrapy WITH PASSWORD '123456';
# it will create the new user in postgres

Create postgres user windows

# in the terminal (not inside psql)
createuser -P --interactive ExampleUser

# Inside psql (using SQL)
CREATE USER john WITH PASSWORD 'mypass' CREATEDB;

Similar codes

0 vote129 views3 answers
When-i-start-ubuntu-it-enters-tty1-6-instead-of-my-desktop-how-do-i-get-to-de/65234#65234
Shell/Bash
1 vote126 views1 answer
Ubuntu auditd show process activity by rules
Shell/Bash
0 vote104 views1 answer
Install composer package from github
Shell/Bash
12 votes101 views2 answers
How to completely remove node from ubuntu
Shell/Bash
0 vote107 views1 answer
Future<void> _getCurrentUserLocation () async { final locData = await Location().getLocation(); final double newLatitude = locData.latitude; final double newLongitude = locData.longitude;
Shell/Bash
1 vote54 views1 answer
How to install fast api
Shell/Bash
7 votes89 views2 answers
How to upload on github with command
Shell/Bash
0 vote94 views3 answers
How to install idle on ubuntu 20.04
Shell/Bash
7 votes98 views1 answer
Update anaconda to current version
Shell/Bash
0 vote101 views1 answer
-----mg: *scratch* (fundamental)----all--------------------------------------------------------------------------------
Shell/Bash