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.