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


From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: <pgsql-bugs(at)postgresql(dot)org>, "Satheesan K Nair" <support(at)shakthiinnovators(dot)com>
Subject: Re: PGDUMP Bug
Date: 2010-10-06 14:27:37
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-bugs
"Satheesan K Nair" <support(at)shakthiinnovators(dot)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.

In response to

  • PGDUMP Bug at 2010-10-06 11:37:05 from Satheesan K Nair


pgsql-bugs by date

Next:From: Tom LaneDate: 2010-10-06 17:49:27
Subject: Re: PGDUMP Bug
Previous:From: Satheesan K NairDate: 2010-10-06 11:37:05
Subject: PGDUMP Bug

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