pg_dump.exe - quotation marks in schema names

From: <sbremal(at)hotmail(dot)com>
To: <pgadmin-support(at)postgresql(dot)org>
Subject: pg_dump.exe - quotation marks in schema names
Date: 2012-02-27 16:22:25
Message-ID: DUB104-W28DC11163C9954158B1858A9690@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support


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...


Cheers
B.

Responses

Browse pgadmin-support by date

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