On 01/06/2010 15:16, Niklas Olsson wrote:
> I run windows xp, pgdemo 1.10.3.
I'm sure you mean pgAdmin. :-)
> I have a schema in one database, export that one.
> Restore in into another database.
> Rename the schema, try to make a backup of it and get the error
>
> pg_dump: No matching schemas were found
> pg_dump: *** aborted because of error
How are you renaming it? Via pgAdmin's interface (right click ->
properties, etc) or with SQL commands though an edit window or psql? If
the latter, you'll need to refresh pgAdmin's view of the schema after
you rename it.
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
rod(at)iol(dot)ie