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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Guillaume Lelarge | 2010-10-23 14:00:37 | Ticket 256: add INSTEAD OF support for triggers |
Previous Message | Dave Page | 2010-10-23 08:36:03 | pgAdmin III commit: Re-order the wxWidgets builds on GTK and Mac to ens |