/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

13 votes271 views2 answers
Get tables in database sql
SQL
1 vote258 views4 answers
Postgres extract date from timestamp
SQL
1 vote266 views2 answers
List tables sqlalchemy
SQL
-1 vote267 views1 answer
Mac mysql workbench console
SQL
1 vote266 views3 answers
Connection string mysql
SQL
1 vote264 views1 answer
Raw query must include primary key
SQL
1 vote267 views1 answer
How to delete a record from sqlite in android
SQL
15 votes280 views5 answers
Show tables in oracle
SQL
1 vote268 views1 answer
Get table column names sql ssms
SQL
0 vote277 views1 answer
[object Object]: BY KimbleOne__DeliveryGroup__c, CreatedDate ^ ERROR at Row:1:Column:142 field 'CreatedDate' can not be grouped in a query call
SQL