Export and import table dump sql using pgAdmin

Question

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

User · Answer

follow he steps  in pgadmin  host-DataBase-Schemas- public  click right  CREATE script- open file - choose xxx sql    then click over the option execute query write result to file  -export data file ok- then click in save its all  it work to me   note  error in version command script enter image description herede sql over pgadmin  can be search  example   http   www forosdelweb com f21 campo-tipo-datetime-postgresql-245389

User · Answer

Click  query tool  button in the list of  tool      And then click the  open file  image button in the tool bar

User · Answer

In pgAdmin  select the required target schema in object tree  databases- gt your db name- gt schemas- gt your target schema  Click on Plugins PSQL Console   in top-bar  Write  i  path to yourfile sql Press enter

User · Answer

If you have Git bash installed  you can do something like this    c Program  Files    x86   PostgreSQL 9 3 bin psql -U  lt pg role name gt  -d  lt pg database name gt   lt   lt path to your gt  sql

User · Answer

An another way  you can do it easily with CMD on Windows  Put your installed version  mine is 11    cd C  Program Files PostgreSQL 11 bin    and run simple query  psql -U  lt postgre username gt  -d  lt db name gt   lt   lt C  path data dump sql gt    enter password then wait the final console message

User · Answer

Using PgAdmin step 1  select schema and right click and go to Backup    step 2  Give the file name and click the backup button     step 3  In detail message copy the backup file path     step 4   Go to other schema and right click and go to Restore   see step 1   step 5   In popup menu paste aboved file path to filename category and click Restore button

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

Examples related to postgresql

Examples related to postgresql-9.2

Examples related to pgadmin