Re: Problem creating backup of schema

I sure mean pgAdmin :)
I rename it via pgAdmin's interface
what is the sql command to rename a schame that way?

/Niklas

> Date: Tue, 1 Jun 2010 15:28:28 +0100
> From: rod(at)iol(dot)ie
> To: niklaso(at)hotmail(dot)com
> CC: pgadmin-support(at)postgresql(dot)org
> Subject: Re: [pgadmin-support] Problem creating backup of schema
>
> 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
>
> --
> Sent via pgadmin-support mailing list (pgadmin-support(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgadmin-support

Chatta från inkorgen. Se möjligheterna med Hotmail! Klicka här!

_________________________________________________________________
Dela kalender. Se möjligheterna med Hotmail!
http://www.microsoft.com/sverige/windows/windowslive/thenewbusy.aspx