From: Guillaume Lelarge <guillaume@lelarge.info>
To: maiesky@poczta.onet.pl
Cc: pgsql-admin@postgresql.org
Subject: Re: Unable to backup table when quotation marks used in the name
Date: Sat, 23 Oct 2010 03:11:44 -0700
Message-ID: <4CC2B4E0.5000708@lelarge.info> (raw)
In-Reply-To: <Q43446609-0d2f9b0739166574e7ee3218c2bb6a73@pmq2.m5r2.onet.test.onet.pl>
References: <Q43446609-0d2f9b0739166574e7ee3218c2bb6a73@pmq2.m5r2.onet.test.onet.pl>
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.frhttp://dalibo.com
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: guillaume@lelarge.info, maiesky@poczta.onet.pl
Subject: Re: Unable to backup table when quotation marks used in the name
In-Reply-To: <4CC2B4E0.5000708@lelarge.info>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox