How to change the owner of a Database in PostgreSQL

First you need to login with the Super User e.g.

psql postgres

After logged-in type the following command

ALTER DATABASE database OWNER TO newuser;

Replace database with your database and newuser with your username

Image Credits: Photo by Isis França on Unsplash.

More Similar Posts

No results found.

Menu