Skip site navigation (1) Skip section navigation (2)

[pgAdmin III] #266: Unable to backup table when quotation marks used in the name

From: "pgAdmin Trac" <trac(at)code(dot)pgadmin(dot)org>
To:
Cc: pgadmin-hackers(at)postgresql(dot)org
Subject: [pgAdmin III] #266: Unable to backup table when quotation marks used in the name
Date: 2010-10-23 10:11:01
Message-ID: 048.5f7fa3468cb6f3a70dc16f900c8509bf@code.pgadmin.org (view raw or flat)
Thread:
Lists: 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

Responses

pgadmin-hackers by date

Next:From: Guillaume LelargeDate: 2010-10-23 14:00:37
Subject: Ticket 256: add INSTEAD OF support for triggers
Previous:From: Dave PageDate: 2010-10-23 08:36:03
Subject: pgAdmin III commit: Build static libraries as well on Windows forthose

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group