[pgAdmin III] #266: Unable to backup table when quotation marks used in the name - Mailing list pgadmin-hackers

#266: Unable to backup table when quotation marks used in the name
---------------------+------------------------------------------------------
 Reporter:  maiesky  |       Owner:  dpage  
     Type:  bug      |      Status:  new    
 Priority:  minor    |   Milestone:         
Component:  pgadmin  |     Version:  1.12   
 Keywords:  backup   |    Platform:  windows
---------------------+------------------------------------------------------
 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\""

--
Ticket URL: <http://code.pgadmin.org/trac/ticket/266>
pgAdmin III <http://code.pgadmin.org/trac/>
pgAdmin III