Hi, I found a bug of restore of pgadminIII v1.20.0 , which I installed by postgresql-9.4 Graphical installer for windows 32bit).
This is my test example: I tried use pgadminIII to restore table A1 in schema publicA in database Vvv1. then it failed and I got the message: D:\Program Files (x86)\PostgreSQL\9.4\bin>pg_restore.exe --host localhost --port 5433 --username "postgres" --dbname "Vvv1" --no-password --data-only --table \"A1\" --schem a \"publicA\" --verbose "C:\Users\Yuanyuan\Desktop\1" ....
I found the table and schema name format is wrong, the right way is like the follwing. and success to restore my table by execute commands like the following: D:\Program Files (x86)\PostgreSQL\9.4\bin>pg_restore.exe --host localhost --port 5433 --username "postgres" --dbname "Vvv1" --no-password --data-only --table "A1" --schema "publicA" --verbose "C:\Users\Yuanyuan\Desktop\1"
I don't know whether anyone has fixed this problem, so I write this to you! please have a look! Thanks and regards!
