I am running pgAdmim 1.12 on WinXP SP3 but this issue was observed in previous releases also. When trying to do a backup of a table which has quotation marks in its name or in schema name then getting error: (example1 quotation marks in schema name)
C:\Program Files\pgAdmin III\1.12\pg_dump.exe --host XXX.com --port 5432 --username XXXX --format plain --data-only --verbose --file "C:\moja.sql" --table "TT_settings".moja "TT_dudulu" pg_dump: No matching tables were found pg_dump: *** aborted because of error
Process returned exit code 1.
or (example2 quotation marks in table name)
C:\Program Files\pgAdmin III\1.12\pg_dump.exe --host XXX.com --port 5432 --username XXXX --format plain --data-only --verbose --file "C:\cwtest2.sql" --table n_dms."CFX" "TT_dudulu" pg_dump: No matching tables were found pg_dump: *** aborted because of error
Process returned exit code 1.
To bypass this problem I can manually run script with added surrounding quotation marks around the access path and escaping chars included in the name: for the first example: "\"TT_settings\".moja"