Re: [BUGS] BUG #8092: pg_dump need sur quoting schema name

2013-04-18 Thread Alvaro Herrera 
xavier.mouton-dub...@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?

-- 
Álvaro Herrerahttp://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training  Services


-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

Re: [BUGS] BUG #8092: pg_dump need sur quoting schema name

2013-04-18 Thread Xavier Mouton-Dubosc 

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

Le 18/04/2013 17:00, Alvaro Herrera a écrit :

xavier.mouton-dub...@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?






--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs