---
title: 'How to Change the Owner of a PostgreSQL Database'
page_title: 'How to Change Owners of PostgreSQL Databases'
page_description: 'You will learn how to change the owner of a database to another in PostgreSQL using the ALTER DATABASE...OWNER TO statement.'
prev_url: 'https://www.postgresqltutorial.com/postgresql-administration/postgres-change-database-owner/'
ogImage: ''
updatedOn: '2024-02-22T10:02:54+00:00'
enableTableOfContents: true
previousLink:
  title: 'How to Get Sizes of Database Objects in PostgreSQL'
  slug: 'postgresql-administration/postgresql-database-indexes-table-size'
nextLink:
  title: 'PostgreSQL Schema'
  slug: 'postgresql-administration/postgresql-schema'
---

**Summary**: in this tutorial, you will learn how to change the owner of a database to another in PostgreSQL.

In PostgreSQL, a database object always has an owner which is the role that created the object including the database.

To change the owner of a database to another, you can use the `ALTER` `DATABASE` statement:

```sql
ALTER DATABASE dbname
OWNER TO new_owner;
```

In this syntax:

- First, specify the database name that you want to change the owner after the `ALTER` `DATABASE` keyword
- Second, specify the new owner, an existing role, in the `OWNER` `TO` clause.

## Changing database owner example

First, [connect to the PostgreSQL](../postgresql-getting-started/connect-to-postgresql-database) using `postgres` user via `psql`:

```bash
psql -U postgres
```

Second, [create a new role](postgresql-roles) with the `CREATEDB` privilege:

```sql
CREATE ROLE alex
WITH CREATEDB LOGIN PASSWORD 'Abcd1234';
```

Third, create another role called `steve`:

```sql
CREATE ROLE steve;
```

Fourth, connect to the PostgreSQL server using the `alex` role:

```bash
psql -U alex
```

Fifth, create a new database called `scm`:

```sql
CREATE DATABASE scm;
```

Sixth, quit `alex`‘s session:

```text
\q
```

Seven, show the `scm` database in the `postgres`‘ session:

```text
\l scm
```

Output:

```text
 Name | Owner | Encoding | Locale Provider |          Collate           |           Ctype            | ICU Locale | ICU Rules | Access privileges
------+-------+----------+-----------------+----------------------------+----------------------------+------------+-----------+-------------------
 scm  | alex  | UTF8     | libc            | English_United States.1252 | English_United States.1252 |            |           |
(1 row)
```

The output shows that the owner of `scm` database is `alex`.

Eight, change the owner of the `scm` database from `alex` to `steve`:

```sql
ALTER DATABASE scm
OWNER TO steve;
```

Ninth, show the `scm` database again:

```text
\l scm
```

Output:

```text
                                                                List of databases
 Name | Owner | Encoding | Locale Provider |          Collate           |           Ctype            | ICU Locale | ICU Rules | Access privileges
------+-------+----------+-----------------+----------------------------+----------------------------+------------+-----------+-------------------
 scm  | steve | UTF8     | libc            | English_United States.1252 | English_United States.1252 |            |           |
(1 row)
```

The output shows that the owner of the `scm` changed to `steve`.

## Summary

- Use the `ALTER DATABASE...OWNER TO` statement to change the owner of a database to a new one.