Unable to backup table when quotation marks used in the name

Поиск
Список
Период
Сортировка
От maiesky@poczta.onet.pl
Тема Unable to backup table when quotation marks used in the name
Дата
Msg-id Q43446609-0d2f9b0739166574e7ee3218c2bb6a73@pmq2.m5r2.onet.test.onet.pl
обсуждение исходный текст
Ответы Re: Unable to backup table when quotation marks used in the name  (Guillaume Lelarge <guillaume@lelarge.info>)
Список pgsql-admin
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"

for second example:
"n_dms.\"CFX\""

В списке pgsql-admin по дате отправления:

Предыдущее
От: "Kevin Grittner"
Дата:
Сообщение: Re: autovacuum launcher process eating up 17G+ of ram?
Следующее
От: maiesky@poczta.onet.pl
Дата:
Сообщение: Can't remove filter when no rows returned