/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

9 votes98 views5 answers
Ffmpeg convert mkv to mp4
Shell/Bash
99 votes116 views6 answers
Npm update latest version
Shell/Bash
137 votes153 views3 answers
Git create empty branch
Shell/Bash
0 vote100 views1 answer
Shh key pair for github
Shell/Bash
12 votes107 views4 answers
Pycharm Ubuntu install
Shell/Bash
72 votes98 views6 answers
See remote git
Shell/Bash
4 votes112 views3 answers
Touch command not recognized in windows
Shell/Bash
0 vote104 views1 answer
Error: error modifying EC2 Volume "vol-04e2b1a2d03860650": InvalidParameterValue: New size cannot be smaller than existing size
Shell/Bash
0 vote102 views3 answers
Delete strings after match to eol using sed command
Shell/Bash
32 votes96 views1 answer
Installer pip3 linux
Shell/Bash