---
title: "Exporting a PostgreSQL database with phpPgAdmin"
description: "After installing PostgreSQL and phpPgAdmin on your server, you can begin to work with PostgreSQL databases. In this tutorial, we will show you how to export your PostgreSQL database using phpPgadmin...."
url: https://www.inmotionhosting.com/support/website/export-database/
date: 2014-03-31
modified: 2021-08-16
author: "InMotion Hosting Contributor"
categories: ["Website", "Working with Databases"]
type: post
lang: en
---

# Exporting a PostgreSQL database with phpPgAdmin

After [installing PostgreSQL and phpPgAdmin](https://www.inmotionhosting.com/support/server/databases/install-setup/) on your server, you can begin to work with PostgreSQL databases. In this tutorial, we will show you how to **export** your **PostgreSQL database** using **phpPgadmin**. Exporting your database allows you to save a backup of it, or [import it](https://www.inmotionhosting.com/support/website/import-database/) into another account.

## How to Export a Database using phpPgAdmin

1.
   1. [Login to cPanel](https://www.inmotionhosting.com/support/edu/cpanel/how-to-log-into-cpanel/).
   2. Click the **phpPgAdmin** button in the *Databases* section.[![](https://www.inmotionhosting.com/support/wp-content/uploads/2014/03/postgresql_export-db_phppgadmin.png)](/support/wp-content/uploads/2014/03/postgresql_export-db_phppgadmin.png)   **Note:** The *phpPgAdmin* button, is only available after [installing PostgreSQL](https://www.inmotionhosting.com/support/server/databases/install-setup/) on your VPS, or Dedicated server.
   3. On the top left, click the name of the database you want to export. You may have to *expand* the **PostgreSQL** option to see the databases.[![](https://www.inmotionhosting.com/support/wp-content/uploads/2014/03/postgresql_export-db_select-database-to-export.png)](/support/wp-content/uploads/2014/03/postgresql_export-db_select-database-to-export.png)  
   4. Click the **Export** tab.[![](https://www.inmotionhosting.com/support/wp-content/uploads/2014/03/postgresql_export-db_select-export-tab.png)](/support/wp-content/uploads/2014/03/postgresql_export-db_select-export-tab.png)  
   5. Choose the format you want to export the database in; I recommend selecting **Structure and data**.[![](https://www.inmotionhosting.com/support/wp-content/uploads/2014/03/postgresql_export-db_select-export-format.png)](/support/wp-content/uploads/2014/03/postgresql_export-db_select-export-format.png)  
   6. In the *Options* section, choose **Download**, or **Download compressed with gzip**, then click the **Export** button.[![](https://www.inmotionhosting.com/support/wp-content/uploads/2014/03/postgresql_export-db_download-export.png)](/support/wp-content/uploads/2014/03/postgresql_export-db_download-export.png)   You will then be prompted to download the database file. Save it to your computer, and you are finished.

 

 

Congratulations, now you know how to export your PostgreSQL database using phpPgAdmin in cPanel! I the next tutorial we will show you how to [import a PostgreSQL](https://www.inmotionhosting.com/support/website/import-database/) database. Learn more about [PostgreSQL Hosting](https://www.inmotionhosting.com/postgresql-hosting) options.