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
min-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.
>
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
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 schema, try to make a backup of it and get the error
p
