Re: pg_dump.exe - quotation marks in schema names

From: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
To: sbremal(at)hotmail(dot)com
Cc: pgadmin-support(at)postgresql(dot)org
Subject: Re: pg_dump.exe - quotation marks in schema names
Date: 2012-02-27 21:23:03
Message-ID: 1330377783.2543.46.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

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

In response to

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Guillaume Lelarge 2012-02-27 21:28:18 Re: Failed to write to history file
Previous Message Michel Boekestein 2012-02-27 21:07:09 Re: Failed to write to history file