How to import/export a PostgreSQL database

How to import/export a PostgreSQL database

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.


    • Related Articles

    • How to import/export a MySQL database

      1 - In cPanel, go to “PhPMyAdmin”; Import: 2 - Click on "Import"; 3 - Click the "Choose File or File" button and select your database (.sql); 4 - Click the "Execute" button; Export: 2 -Choose the database you want to export from the list on the left; ...

    • How to upload a firebird database to your hosting acount

      If you already have a Firebird database and want to upload it to your hosting account, just follow these steps: Step 1 1. Save/export your local database with the user that accesses your hosting. The password must contain exactly 8 characters, you ...

    • How to export your database in phpMyAdmin?

      To export your database on phpMyadmin, you must access phpMyadmin through cPanel.  - You must choose the database you want to export.  - Click on the MySQL database you want to export, it is located on the left side, as shown in the following image: ...

    • How to import a database in PhpMyAdmin?

      Step 1 1 - In cPanel, go to “PhPMyAdmin”; Step 2 In the top bar of your PHPmyadmin click on "Import"; Click the "Choose File or File" button and select your database (.sql); Step 3 Then correctly define the settings you want for import as in the ...

    • How to create a PostgreSQL database

      Here is a step-by-step guide to creating a PostgreSQL database on your hosting. 1. Login to cPanel: Access cPanel using your user credentials and password provided by your hosting provider. 2. Locate the “Databases” section: In the main cPanel ...