How to change the owner of a Database in PostgreSQL

7 sec read

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

Last Updated On April 07, 2018

Leave a Reply

Notify of