How to import/export a PostgreSQL database

Á

Álvaro Moura

Last updated on Jul 13, 2026

Important: First you need to create a PostgreSQL database following this tutorial: https://help.scriptcase.net/portal/pt/kb/articles/banco-de-dados-postgresql

1 - In cPanel, access “phpPgAdmin”;


To import:

2 - In the left panel of the screen, click on PostgreSQL and then on the name of the destination database for the imported data;


3 - When clicking on the desired bank, click on the "SQL" button;


4 - Click the "Choose file" button, select the ".sql" file from your device and then click the "Run" button;


To export:

1 - Expand (click on the +) the PostgreSQL option in the list on the left;


2 - Choose the database you want to export.


3 - Click on the "Export" option;

4 - Select the "Structure and data" option;

5 - Change the format to "SQL";

6 - Select the "Download" option and click "Export". The system will ask you where you want to save the bank on your device.