Thread: PGDUMP Bug

PGDUMP Bug

From
"Satheesan K Nair"
Date:
Dear PGSQL Master,

I have a data base in PostgreSql 8.1 version. I have created an Additional =
Schema named "Jay Jay Mills Lanka (Private) Limited". There is 475 tables i=
n this schema and I want to take table-wise backup.=20

But its giving the error. Please refer below command line.


C:\pgsql\bin>pg_dump.exe -h dbserver -p 5432 -U streamline -F c -v -f "C:\b=
ackup\wrm_batch.backup" -t wrm_batch -n "Jay Jay Mills Lanka (Private) Limi=
ted" "16mar10"
pg_dump: No matching schemas were found
pg_dump: *** aborted because of error



Thanks and regards,
Satheesan K Nair=

Re: PGDUMP Bug

From
"Kevin Grittner"
Date:
"Satheesan K Nair" <support@shakthiinnovators.com> wrote:

> C:\pgsql\bin>pg_dump.exe -h dbserver -p 5432 -U streamline -F c -v
> -f "C:\backup\wrm_batch.backup" -t wrm_batch -n "Jay Jay Mills
> Lanka (Private) Limited" "16mar10"

I don't know about Windows, but on Linux you would need apostrophe
quoting around the double-quotes in that context:

-n '"Jay Jay Mills Lanka (Private) Limited"'

Otherwise the OS eats your quote characters and PostgreSQL doesn't
know about them, so it would fold the schema name to lower case.

-Kevin

Re: PGDUMP Bug

From
Tom Lane
Date:
"Kevin Grittner" <Kevin.Grittner@wicourts.gov> writes:
> "Satheesan K Nair" <support@shakthiinnovators.com> wrote:
>> C:\pgsql\bin>pg_dump.exe -h dbserver -p 5432 -U streamline -F c -v
>> -f "C:\backup\wrm_batch.backup" -t wrm_batch -n "Jay Jay Mills
>> Lanka (Private) Limited" "16mar10"

> I don't know about Windows, but on Linux you would need apostrophe
> quoting around the double-quotes in that context:

> -n '"Jay Jay Mills Lanka (Private) Limited"'

> Otherwise the OS eats your quote characters and PostgreSQL doesn't
> know about them, so it would fold the schema name to lower case.

Not only case-folding: the argument of -n is actually a regex pattern,
and parentheses are special in regexes.  The double quotes would fix
both of those things though.

Personally I'd think twice or three times about using a schema name like
that.  But you can do it, if you can figure out how to get Windows to
include a double quote in a command argument.

            regards, tom lane