/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

1 vote119 views1 answer
Copy whole directory command line
Shell/Bash
0 vote128 views2 answers
Status code 409 sudo has snap-install
Shell/Bash
91 votes180 views7 answers
React-router-dom
Shell/Bash
0 vote106 views2 answers
Sum of files size in linux
Shell/Bash
0 vote108 views1 answer
Fslmerge
Shell/Bash
0 vote111 views1 answer
If the {string} part is omitted, it is considered as an empty string, and the matched pattern is deleted. The following command deletes all instances of the string ‘foo’ in the current line
Shell/Bash
2 votes100 views4 answers
Rollback git
Shell/Bash
0 vote111 views2 answers
Create file from terminal using cat
Shell/Bash
2 votes97 views2 answers
Sum column bash
Shell/Bash
1 vote96 views2 answers
Command to uninstall windows store
Shell/Bash