With mysql and am sure countless other database softwares, it is pretty easy to create a new database, create a new user and grant that user to own and be able to do everything on that database
this is NOT the case with postgresql Every time i am about to create a new database and user on postgresql it is a such a pain to think about because i KNOW i will come across head ache again
Why is postgresql such a pain with uses and database and allowing a user to own a database so the user/role has all permissions
It is crazy to always be getting errors like
permission denied for table sites
How can one create a new database, new user with password and grant ownership of the new database to that new user so the user/role can do EVERY and ANYTHING on that new database? what commands to achieve all these? for postgresql?