How to import an .sql file into a Postgre database?

Log in to your cPanel and open the phpPgAdmin tool. Then click on the PostgreSQL link at the left tree menu and log in to the Postgre server using your cPanel login details.
Next, select the database you want to import data into and click on the SQL button.

You have two options. You can either paste the SQL queries in the provided field or you can upload a local file to be executed. In order to execute a local Postgre SQL script, press the "Browse" button and locate the .sql file on your local computer.

Once you have done that, click on the "Run" button and the queries from your file will be uploaded and executed on your database.

  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

What is the default mysql port?

3306 is the default mysql port.

How to connect to PostgreSQL from PHP?

For connecting to a PostgreSQL database from PHP you can use the standard pg_Connect() function.

How to create a Postgre user?

In order to create a PostgreSQL user you should go to your cPanel -> PostgreSQL Databases...

How to create a Postgre database?

Creating a PostgreSQL database is a straight-forward process. All you need to do is log in to...

Is it possible to use a Postgre database for application installation?

It is possible to use a PostgreSQL database for all applications that support this database type....