Export and import table dump (.sql) using pgAdmin
PostgresqlPostgresql 9.2PgadminPostgresql Problem Overview
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?
Postgresql Solutions
Solution 1 - Postgresql
- In pgAdmin, select the required target schema in object tree (databases ->your_db_name -> schemas -> your_target_schema)
- Click on Plugins/PSQL Console (in top-bar)
- Write
\i /path/to/yourfile.sql
- Press enter
Solution 2 - Postgresql
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 <postgre_username> -d <db_name> < <C:\path\data_dump.sql>
enter password then wait the final console message.
Note: Make sure to remove <> from the above query except for the < between db_name & file path.
Example: psql -U postgres -d dumb_db < D:\db_dump.sql
Solution 3 - Postgresql
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.
Solution 4 - Postgresql
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/
Solution 5 - Postgresql
Click "query tool" button in the list of "tool".
And then click the "open file" image button in the tool bar.
Solution 6 - Postgresql
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