Re: Copy of a schema - Mailing list pgsql-general

From A. Kretschmer
Subject Re: Copy of a schema
Date
Msg-id 20051027093328.GB24904@webserv.wug-glas.de
Whole thread Raw
In response to Copy of a schema  (Frederic Massot <frederic@juliana-multimedia.com>)
List pgsql-general
am  27.10.2005, um 11:13:43 +0200 mailte Frederic Massot folgendes:
> Hi,
>
> I wonder whether it is possible to copy a schema with a postgreSQL command
> like "copy_schema schema_src schema_dest" ?

You can rename a schema. And, you can make a dump, then rename it, and
then restore from backup. Or, make a backup, edit this file and restore
it.

Attention: if you have sequences (for instance), you getting problems
because the table-definitions references the wrong schema.


HTH, Andreas
--
Andreas Kretschmer    (Kontakt: siehe Header)
Heynitz:  035242/47212,      D1: 0160/7141639
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
 ===    Schollglas Unternehmensgruppe    ===

pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: improve 'where not exists' query..
Next
From: "surabhi.ahuja"
Date:
Subject: Re: a stored procedure ..with integer as the parameter