Le 01/06/2010 16:16, Niklas Olsson a écrit :
>
> Hi
> I run windows xp, pgdemo 1.10.3.
> In this version I can no longer create a backup when schema has been
> changed.
> this is what I do,
>
> I have a schema in one database, export that one.
> Restore in into another database.
> Rename the sc
On 03/06/2010 08:22, Niklas Olsson wrote:
>
>
> I sure mean pgAdmin :)
:-)
> I rename it via pgAdmin's interface
> what is the sql command to rename a schame that way?
Here you go:
http://www.postgresql.org/docs/8.4/static/sql-alterschema.html
However, if you're renaming via pgAdmin, then
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: [pgad
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
