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: r...@iol.ie
> To: nikl...@hotmail.com
> CC: pgadmin-support@postgresql.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
> r...@iol.ie
>
> --
> Sent via pgadmin-support mailing list (pgadmin-support@postgresql.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
