/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

0 vote132 views1 answer
Sum values by month mariadb
SQL
0 vote175 views1 answer
Capabilities of sql select statements
SQL
0 vote136 views2 answers
How to generate a unique random number in mysql
SQL
1 vote136 views1 answer
Convert epoch to date in sql server
SQL
0 vote141 views2 answers
Dumping sql table
SQL
3 votes133 views2 answers
Df to sql pandas sql achemy
SQL
0 vote121 views1 answer
Where in clause tsql
SQL
6 votes141 views3 answers
Date_trunc postgres
SQL
0 vote171 views1 answer
Display all node label neo4j
SQL
0 vote143 views1 answer
Nodejs sql get one to many relationship as array
SQL