Export and import dump table (.sql) using pgAdmin

Question

I have pgAdmin version 1.16.1

So, to export the dumm table, I do:

Right-click on the table, then click backup in the menu, then in Format select Plain and save the file as some_name.sql

Then I delete the table.

Ok, now I need a backup of the import table some_name.sql to the database.

How to do it? I cannot find how to import a .sql table into a database using pgAdmin.

Can you help me?

Answer 1

• In pgAdmin, select the desired target schema in the object tree
• Click on PSQL Plugins / Console
• Write \i /path/to/yourfile.sql
• Press enter

Answer 2

follow him. in pgadmin

host-DataBase-Schemas-public (right-click) CREATE script- open file - (select xxx.sql), then click on the option to query the write request to the data file -export ok-, then click on save.its all. it works for me.

note: an error in the command script version enter the image description here de sql over pgadmin can be found, example: http://www.forosdelweb.com/f21/campo-tipo-datetime-postgresql-245389/

Answer 3

Using PgAdmin, step 1: select the scheme and right-click and go to Backup.

step 2: give the file name and click the backup button.

Step 3: In the detailed message, copy the path to the backup file.

step 4:

Switch to another diagram and right-click and go to Restore. (see step 1)

step 5:

In the pop-up menu, insert the above path to the file and click the "Restore" button.

Answer 4

If you have Git bash installed, you can do something like this:

 /c/Program\ Files\ \(x86\)/PostgreSQL/9.3/bin/psql -U <pg_role_name> -d <pg_database_name> < <path_to_your>.sql 

Answer 5

Click the Request Tool button in the Tool list.

And then click the button with the image “open file” on the toolbar.

Answer 6

In another way, you can do it easily with CMD on Windows

Install the installed version (I have 11).

 cd C:\Program Files\PostgreSQL\11\bin\ 

and run a simple query

 psql -U <postgre_username> -d <db_name> < <C:\path\data_dump.sql> 

enter the password and wait for the last console message.