Received: from maia.hub.org (unknown [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id E403D1337B3E for ; Sat, 23 Oct 2010 07:12:02 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 44055-03 for ; Sat, 23 Oct 2010 10:11:55 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from sd-17937.dedibox.fr (sd-17937.dedibox.fr [88.191.100.74]) by mail.postgresql.org (Postfix) with ESMTP id 0FE11133729E for ; Sat, 23 Oct 2010 07:11:55 -0300 (ADT) Received: from [172.16.1.231] (unknown [209.118.182.93]) by sd-17937.dedibox.fr (Postfix) with ESMTPA id 3FD5E3B8F5; Sat, 23 Oct 2010 12:11:53 +0200 (CEST) Message-ID: <4CC2B4E0.5000708@lelarge.info> Date: Sat, 23 Oct 2010 03:11:44 -0700 From: Guillaume Lelarge User-Agent: Mozilla/5.0 (X11; U; Linux i686 (x86_64); fr; rv:1.9.2.11) Gecko/20101013 Thunderbird/3.1.5 MIME-Version: 1.0 To: maiesky@poczta.onet.pl CC: pgsql-admin@postgresql.org Subject: Re: Unable to backup table when quotation marks used in the name References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-2 Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9 X-Spam-Level: X-Archive-Number: 201010/173 X-Sequence-Number: 35914 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