/SQL/Create and attach user to a postgresql database

Create and attach user to a postgresql database

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

GRANT ALL PRIVILEGES ON DATABASE yourdbname TO youruser;

Source: medium.com

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

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

Source: medium.com

Create and attach user to a postgresql database

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

19 votes150 views5 answers
Display table in sql
SQL
0 vote182 views3 answers
Characters found after end of sql statement
SQL
1 vote199 views1 answer
Oracle datafile max size 32gb
SQL
0 vote138 views1 answer
Sql sort ages
SQL
2 votes137 views1 answer
How to select first row of database sql
SQL
1 vote181 views1 answer
Psql client write to bash variable
SQL
25 votes151 views5 answers
Uninstall mysql ubuntu
SQL
0 vote138 views1 answer
Postgres 11 add primary key
SQL
2 votes136 views1 answer
Set column to not null mysql
SQL
0 vote139 views1 answer
Contact mysql column field
SQL