I am using pgAdmin version 1.14.3. PostgreSQL database version is 9.1.
I got all Db script for table creation but unable to export all data inside tables. Could not find any option to export data in db script form.
Erwin Brandstetter
668k159 gold badges1.2k silver badges1.3k bronze badges
asked Jun 29, 2012 at 6:34
Muhammad Imran Tariq
23.4k47 gold badges130 silver badges191 bronze badges
-
1If anyone want for whole DB then look Export and Import of PostgresSQL with pgAdmin IIISomnath Muluk– Somnath Muluk2016-08-26 13:30:37 +00:00Commented Aug 26, 2016 at 13:30
-
You can try in online demo choose.tools/tool?id=pgAdminMichael Podgortsev– Michael Podgortsev2020-01-22 19:27:46 +00:00Commented Jan 22, 2020 at 19:27
Add a comment
|
3 Answers
- Right-click on your table and pick option
Backup.. - On File Options, set Filepath/Filename and pick
PLAINfor Format - Ignore Dump Options #1 tab
- In Dump Options #2 tab, check
USE INSERT COMMANDS - In Dump Options #2 tab, check
Use Column Insertsif you want column names in your inserts. - Hit
Backupbutton
Edit: In case you are using pgAdmin on a remote server: Once the UI announces the backup was successful, you might want to download the data. For this, follow these steps:
- Click on Tools (in the menu)
- Select Storage Manager
- Select the file that was just created
- Click on the small "Download File" button
8 Comments
StealthTrails
where this backup went?
fresko
Maybe this work if your DB is in local. In my case, there is a message announcing the victory, but the file disappears on the server. I want to DOWNLOAD it on my computer. :/
cadavre
pgAdmin is most ridiculous IT tools I've ever used. There's anything like UX in pgAdmin.
ccallendar
I couldn't find the file that was generated, so I ended up using the command that pgAdmin used (click on "More Details" in pgAdmin after running Backup), and opening a shell on the server and running the same command, then I could copy the file.
Janaka Peiris
for File Name give a file with a full path (eg: /home/xxx/yyy/backup.sql"), Then if it gives an error saying cannot find that message has the default path it tries to save.
|
Just right click on a table and select "backup". The popup will show various options, including "Format", select "plain" and you get plain SQL.
pgAdmin is just using pg_dump to create the dump, also when you want plain SQL.
It uses something like this:
pg_dump --user user --password --format=plain --table=tablename --inserts --attribute-inserts etc.
10 Comments
Muhammad Imran Tariq
it generates dump having table data script starts with COPY command not INSERT. Anyway to generate script with INSERT commands.
Frank Heikens
That's why you have to create plain SQL. When using the dump option INSERT, you get ordinary INSERT queries
Frank Heikens
@Pixel Elephant: If performance matters, you should use COPY. It's much faster.
jpmc26
In pgAdmin III 1.16.1, "Use Insert commands" is under Dump Option #2.
bhdrkn
In pgAdmin III 1.18.1, Select Plain for Format under File Option and than check "Use Insert commands" under Dump Option #2.
|
In the pgAdmin4, Right click on table select backup like this
After that into the backup dialog there is Dump options tab into that there is section queries you can select Use Insert Commands which include all insert queries as well in the backup.
