Hello
"pg_dump" seems to have an issue with schema names containing quotation marks ("). The values do not get passed to the
toolproperly.
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.