Re: Problem creating backup of schema

<br /><style>
.ExternalClass .ecxhmmessage P
{padding:0px;}
.ExternalClass body.ecxhmmessage
{font-size:10pt;font-family:Verdana;}
</style>  <br />I sure mean pgAdmin :)<br />I rename it via pgAdmin's interface<br />what is the sql command to rename
aschame that way?<br /> <br />/Niklas<br /> <br />> Date: Tue, 1 Jun 2010 15:28:28 +0100<br />> From:
rod@iol.ie<br/>> To: niklaso@hotmail.com<br />> CC: pgadmin-support@postgresql.org<br />> Subject: Re:
[pgadmin-support]Problem creating backup of schema<br />> <br />> On 01/06/2010 15:16, Niklas Olsson wrote:<br
/>>> I run windows xp, pgdemo 1.10.3.<br />> <br />> I'm sure you mean pgAdmin. :-)<br />> <br />>
>I have a schema in one database, export that one.<br />> > Restore in into another database.<br />> >
Renamethe schema, try to make a backup of it and get the error<br />> > <br />> > pg_dump: No matching
schemaswere found<br />> > pg_dump: *** aborted because of error<br />> <br />> How are you renaming it?
ViapgAdmin's interface (right click -><br />> properties, etc) or with SQL commands though an edit window or
psql?If<br />> the latter, you'll need to refresh pgAdmin's view of the schema after<br />> you rename it.<br
/>><br />> Ray.<br />> <br />> <br />> -- <br />> Raymond O'Donnell :: Galway :: Ireland<br />>
rod@iol.ie<br/>> <br />> -- <br />> Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)<br
/>>To make changes to your subscription:<br />> http://www.postgresql.org/mailpref/pgadmin-support<br /><br /><hr
/>Chatta från inkorgen. Se möjligheterna med Hotmail! <a href="http://springpack.msn.se/">Klicka här!</a><br /><br
/><hr/>Hotmail i mobilen på 5 sekunder! <a href="http://www.microsoft.com/sverige/windows/windowslive/thenewbusy.aspx"
target="_new">Klickahär!</a>