---
title: "How to Import a PostgreSQL database using phpPgAdmin"
description: "Now that you've installed PostgreSQL and phpPgAdmin on your server, you can begin to create and manage databases. In this tutorial, we'll show you how to import a PostgreSQL database using phpPgAdmin..."
url: https://www.inmotionhosting.com/support/website/import-database/
date: 2014-04-03
modified: 2022-03-31
author: "InMotion Hosting Contributor"
categories: ["Website", "Working with Databases"]
type: post
lang: en
---

# How to Import a PostgreSQL database using phpPgAdmin

Now that you’ve [installed PostgreSQL and phpPgAdmin](https://www.inmotionhosting.com/support/server/databases/install-setup/) on your server, you can begin to create and manage databases. In this tutorial, we’ll show you how to **import a PostgreSQL database using phpPgAdmin** in cPanel.

You must [create a PostgreSQL database](https://www.inmotionhosting.com/support/website/create-database/) before you can complete this guide.

## Importing a Database with phpPgAdmin

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 database you want to import the backup into. [![](https://www.inmotionhosting.com/support/wp-content/uploads/2014/04/postgresql_import-db_select-database.png)](/support/wp-content/uploads/2014/04/postgresql_import-db_select-database.png)
4. Click the **SQL** tab. [![](https://www.inmotionhosting.com/support/wp-content/uploads/2014/04/postgresql_import-db_sql-tab.png)](/support/wp-content/uploads/2014/04/postgresql_import-db_sql-tab.png)
5. Click the **Browse** button, and select your database backup file, and click **Open**. [![](https://www.inmotionhosting.com/support/wp-content/uploads/2014/04/postgresql_import-db_choosing-database-to-import.png)](/support/wp-content/uploads/2014/04/postgresql_import-db_choosing-database-to-import.png)
6. Click the **Execute** button to begin the import process. This will take some time depending on the size of the database. When you see a *SQL Executed* message, you are finished. You will also see that your tables are now populated. [![](https://www.inmotionhosting.com/support/wp-content/uploads/2014/04/postgresql_import-db_sql-executed.png)](/support/wp-content/uploads/2014/04/postgresql_import-db_sql-executed.png)

Congratulations, now you know how to **import** a **PostgreSQL database** using **phpPgAdmin**! Learn more about [PostgreSQL Hosting](https://www.inmotionhosting.com/postgresql-hosting) options.