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

Re: PGDUMP Bug

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: 4CAC410902000025000365AF@gw.wicourts.gov (view raw or flat)
Thread:
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.
 
-Kevin

In response to

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

Responses

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-2014 The PostgreSQL Global Development Group