/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

5 votes239 views1 answer
Migrate sql table another database
SQL
5 votes163 views2 answers
Sql conn
SQL
10 votes123 views2 answers
Django mysql
SQL
0 vote141 views1 answer
Online sql compiler
SQL
0 vote169 views1 answer
How to know if table in rigt or left in sql
SQL
0 vote243 views1 answer
How to get number of months between 2 dates sql server
SQL
3 votes195 views1 answer
Oracle undo tablespace schema
SQL
1 vote185 views1 answer
Where not in array sql
SQL
0 vote174 views1 answer
Pip install mysqlclient error
SQL
0 vote177 views1 answer
Drop CHECK constraint sql
SQL