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