How to import and export PostgreSQL databases with phpPgAdmin

16 de agosto, 2016 @ 12:25 — 0 comentarios

phpPgAdmin is a web based PostgreSQL manager, it can be used to create  tables, views, esquemas... etc

Access to phpPgAdmin

To access to  phpPgAdmin, we first need to access to our Hosting Panel, descend to section "Mysql and PostgreSQL databases" and click on "phpPgAdmin" icon.

PostgreSQL_001

 

phpPgAdmin web manager will pop up in a new window

phppgadmin_001

 

By clicking on your Database name, "d4b62df4_8cb78fc7" in this example, you will get access to database operations.

 

Operations

Import

Importing of a Database is made in the SQL section, click on "SQL" icon.
phppgadmin_002

 

You will see a new text area where you can post your SQL querys. Additionally  you could upload a SQL script to import an entire database.

phppgadmin_003

 

you just need to select the file or write you query and click on the "Execute" button.

 

Export

To export your database you need to click on "Export" icon.

phppgadmin_004

 

A new dialog will show up with different format and options.
phppgadmin_005

 

It may be recommendable to select  "Structure and data" with "SQL" Format and remember to select  "Download compressed with gzip" option.