Psql create user

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

How to create a new user in postgresql

CREATE DATABASE yourdbname;CREATE USER youruser WITH ENCRYPTED PASSWORD 'yourpass';GRANT ALL PRIVILEGES ON DATABASE yourdbname TO youruser;

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

How do I add a user to a postgres database? cli

psql=# grant all privileges on database <dbname> to <username>

Source: medium.com

Similar codes

1 vote125 views1 answer
Postgresql convert text to float
SQL
0 vote133 views1 answer
Insert overwrite table in mysql in nifi
SQL
1 vote126 views1 answer
Too many connections mysql
SQL
0 vote240 views1 answer
Multiple replace value mssql
SQL
57 votes300 views6 answers
Mysql alter table add column
SQL
13 votes123 views5 answers
Alter table query sql server change column
SQL
19 votes130 views3 answers
Grant mysql
SQL
0 vote182 views1 answer
SQL Server Altering Column to be Unique
SQL
0 vote147 views1 answer
Delet all record statment sql
SQL
0 vote138 views1 answer
A good way of running a SQL query in JDBC using a parameterized statement
SQL