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

Re: pg_dump.exe - quotation marks in schema names

From: <sbremal(at)hotmail(dot)com>
To: <guillaume(at)lelarge(dot)info>
Cc: <pgadmin-support(at)postgresql(dot)org>
Subject: Re: pg_dump.exe - quotation marks in schema names
Date: 2012-02-28 10:33:08
Message-ID: DUB104-W64E6025F8F447E419A5E45A96E0@phx.gbl (view raw or flat)
Thread:
Lists: pgadmin-support
Work like a charm! Thanks.


B.

> Subject: Re: [pgadmin-support] pg_dump.exe - quotation marks in schema names
> From: guillaume(at)lelarge(dot)info
> To: sbremal(at)hotmail(dot)com
> CC: pgadmin-support(at)postgresql(dot)org
> Date: Mon, 27 Feb 2012 22:23:03 +0100
> 
> On Mon, 2012-02-27 at 16:22 +0000, sbremal(at)hotmail(dot)com wrote:
> > Hello
> > 
> > "pg_dump" seems to have an issue with schema names containing quotation marks ("). The values do not get passed to the tool properly.
> > 
> > From Pgadmin:
> > 
> > C:\Program Files\pgAdmin III\1.10\pg_dump.exe --host localhost --port 5432 --username xxx --format plain --schema-only --verbose --file "C:\schema.sql" --schema "ACCOUNTING" postgres
> > pg_dump: No matching schemas were found
> > pg_dump: *** aborted because of error
> > Process returned exit code 1.
> > 
> > From the command line:
> > 
> > "C:\Program Files\pgAdmin III\1.10\pg_dump.exe" --host localhost --port 5432 --username ccc --format plain --schema-only --verbose --file "C:\schema.sql" --schema "\"ACCOUNTING\"" postgres
> > 
> > Not sure this is a Windows or reqular expression issue but it is annoying for us as all our schemas has double quotes.
> > 
> > Maybe there is a quick remedy...
> > 
> 
> Update to 1.14 (latest is out today), and check if it works for you (it
> does for me, but I'm on Linux and cannot test it on Windows now).
> 
> 
> -- 
> Guillaume
> http://blog.guillaume.lelarge.info
> http://www.dalibo.com
> 
> 
> -- 
> Sent via pgadmin-support mailing list (pgadmin-support(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgadmin-support 		 	   		  

In response to

pgadmin-support by date

Next:From: Guillaume LelargeDate: 2012-02-28 11:01:20
Subject: Re: pgAdmin hangs
Previous:From: Bartosz DmytrakDate: 2012-02-28 09:10:34
Subject: pgAdmin hangs

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