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

From: Xavier Mouton-Dubosc <xavier(dot)mouton-dubosc(at)notalus(dot)fr>
To: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #8092: pg_dump need sur quoting schema name
Date: 2013-04-18 15:45:51
Message-ID: 5170152F.8070809@notalus.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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

Le 18/04/2013 17:00, Alvaro Herrera a écrit :
> xavier(dot)mouton-dubosc(at)notalus(dot)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?
>

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message bmohareb 2013-04-18 16:20:19 BUG #8093: After starting postgres, any attempt to connect generate a core dump and unable to login
Previous Message Alvaro Herrera 2013-04-18 15:00:35 Re: BUG #8092: pg_dump need sur quoting schema name