postgres grant all privileges to user on database windows 10

 To allow a postgres db user to all privileges follow bellow instructions - 

From commend line run bellow commend - 

C:\Users\HP>psql -X -U postgres 

Now enter the postgress password - 

Password for user postgres:
psql (13.4)
WARNING: Console code page (437) differs from Windows code page (1252)
         8-bit characters might not work correctly. See psql reference
         page "Notes for Windows users" for details.
Type "help" for help.

postgres=#

Now execute commend as bellow - 

GRANT ALL PRIVILEGES ON database database_name TO user_name;

Here  - 

database_name is your database name.

user_name is your postgress username, you want give privilege to your database.

If this article is useful to you please write a comment bellow. Also let us know what kind of solution/tutorial/article you expect from this site.