Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Welcome To Ask or Share your Answers For Others

Categories

0 votes
1.2k views
in Technique[技术] by (71.8m points)

postgresql - Export and import table dump (.sql) using pgAdmin

I have pgAdmin version 1.16.1

So, for exporting table dumm I do:

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

Then I remove table.

Ok, now I need import table backup some_name.sql into database.

How to do this? I can't find how to import table's .sql dump into database using pgAdmin.

Can you help me please?

See Question&Answers more detail:os

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

1 Answer

0 votes
by (71.8m points)
  1. In pgAdmin, select the required target schema in object tree (databases ->your_db_name -> schemas -> your_target_schema)
  2. Click on Plugins/PSQL Console (in top-bar)
  3. Write i /path/to/yourfile.sql
  4. Press enter

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Click Here to Ask a Question

...