Thread: Unable to backup table when quotation marks used in the name
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\""
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\""
Le 20/10/2010 05:28, maiesky@poczta.onet.pl a écrit : > 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\"" > I added a ticket (http://code.pgadmin.org/trac/ticket/266) to work on this when we'll have some time. Thanks for your report. -- Guillaume http://www.postgresql.fr http://dalibo.com