Learn to import .sql file into a Postgre database

Follow these steps to import a .sql file into a PostgreSQL database:

1. Log in to your cPanel account.

2. Open the phpPgAdmin tool.

3. Click on the PostgreSQL link in the left tree menu and log in to the PostgreSQL server using your cPanel credentials.

4. Identify and select the database where you want to import data, then click on the SQL button.

5. Choose one of the two options:

(a) Paste the SQL queries into the provided field, or

• (b) Upload a local file to be executed. Click the Browse button to locate the .sql file on your local computer for executing a local PostgreSQL SQL script.

6. Click the Run button. The queries from your file will be uploaded and executed on your PostgreSQL database.

That's it! Your .sql file has been successfully imported into the PostgreSQL database.