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 upload a firebird database to your hosting acount

      If you already have a Firebird database and want to host in our host account, just follow these steps: 1- Save/export your local firebird database with your cpanel username and password (the first one that was sent to your email) as the owner ...

    • 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?

      To import your database into phpMyadmin, you must access phpMyadmin through cpanel.  When you are in phpMyAdmin, you must choose a database into which the data will be imported (the empty database), which is located on the left, as shown in the ...

    • Import a CSV file to MYSQL via PHPMYADMIN

      I was given access to an existing instance of MySQL via phpMyAdmin. My task was to import a CSV file using the import feature on phpMyAdmin. First, I went to the the main phpMyAdmin page. Next, I clicked on the database instance that I am interested. ...

    • Creating a MySQL Database

      The MySQL database allows you to store a lot of information with ease of access. Before using the database, first you must create one. Also, you need to create at least one MySQL user to access the database. Step 1 At your cPanel, in the "DATABASES" ...