/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

1 vote193 views1 answer
Truncate left characters mysql
SQL
0 vote190 views1 answer
Truncate table sql server foreign key
SQL
0 vote182 views1 answer
How to find unique key in sql
SQL
0 vote202 views1 answer
Mysql count number of occurrences in a column
SQL
1 vote246 views1 answer
Psql client write to bash variable
SQL
2 votes210 views2 answers
How to get the date diff of 2 dates in the same fieldin sql server
SQL
0 vote198 views1 answer
T-sql update table variale
SQL
0 vote217 views1 answer
What is database username and password in mysqliconnect
SQL
0 vote202 views1 answer
Add multiple field in table sql
SQL
0 vote214 views1 answer
The report definition has an invalid target namespace 'http://schemas.microsoft.com/SQLServer/reporting/reportdesigner'
SQL