Thread: BUG #8092: pg_dump need sur quoting schema name

The following bug has been logged on the website:

Bug reference:      8092
Logged by:          Xavier Mouton-Dubosc
Email address:      xavier.mouton-dubosc@notalus.fr
PostgreSQL version: 9.2.4
Operating system:   Linux Ubuntu 12.10
Description:        =


When I dump "default" schema
pg_dump -s  --schema=3D"default" --username=3D"user" --host=3D"localhost" =

--quote-all-identifiers --serializable-deferrable "base"

works well. But when I try to dump "other" schema
pg_dump -s  --schema=3D"other" [...]

I have this error:
pg_dump: No matching schemas were found

I have to surquote schema name to have it working
pg_dump -s  --schema=3D"\"other\"" [...]

seems strange

xavier.mouton-dubosc@notalus.fr wrote:

> works well. But when I try to dump "other" schema
> pg_dump -s  --schema=3D"other" [...]
>=20
> I have this error:
> pg_dump: No matching schemas were found
>=20
> I have to surquote schema name to have it working
> pg_dump -s  --schema=3D"\"other\"" [...]
>=20
> seems strange

Does your "other" schema have uppercase letters or some such?

--=20
=C1lvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services

Yes.
structure is kind of [a-zA-Z0-9\-_]{4,}

Le 18/04/2013 17:00, Alvaro Herrera a écrit :
> xavier.mouton-dubosc@notalus.fr wrote:
>
>> works well. But when I try to dump "other" schema
>> pg_dump -s  --schema="other" [...]
>>
>> I have this error:
>> pg_dump: No matching schemas were found
>>
>> I have to surquote schema name to have it working
>> pg_dump -s  --schema="\"other\"" [...]
>>
>> seems strange
> Does your "other" schema have uppercase letters or some such?
>