Importing a .sql file in PostgreSQL database

For importing a .sql file in PostgreSQL database you should follow the given steps

1. Log into your cPanel account

2. Open the phpPgAdmin tool

3. Click on PostgreSQL button on the left tree menu

4. Log into the Postgre server using your cPanel login information

5. Now select the database where you want to import data

6. Click on the SQL button

7. 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.

8. Now click the RUN button. Now queries are  uploaded and ready to be executed.

 

 

هل كانت المقالة مفيدة ؟ 2 أعضاء وجدوا هذه المقالة مفيدة (28 التصويتات)

مقالات مشابهة

Creating a PostGre Database

PostgreSQL databases are very easy to make. One has to go to CPanel , inside it there is a sub...

 Connecting a PostgreSQL from PHP

For connecting a PostgreSQL to PHP you may use the standard pg Connect () function  

 Creating a PostGre User

Creating a Postgre user is very easy . Just login into your CPanel and goto the PostgreSQL...