/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 vote382 views1 answer
Base64 encode sql server
SQL
0 vote329 views1 answer
Sql get table last modified time
SQL
0 vote360 views1 answer
Query to generate query to drop primary keys or foreign key in ms sql server
SQL
0 vote333 views1 answer
Update table sql multiple set
SQL
0 vote375 views1 answer
Running mysql from bash sc
SQL
2 votes395 views2 answers
Mysql compare datetime to another datetime
SQL
0 vote335 views1 answer
Remove transient options sql wordpress
SQL
0 vote342 views1 answer
What is default mysql database password in linux
SQL
0 vote382 views1 answer
Oracle concat datetime
SQL
0 vote365 views1 answer
Shows all databases created by user in ms sql
SQL