Re: Copy of a schema

Поиск
Список
Период
Сортировка
Искать

Re: Copy of a schema

От:
"A. Kretschmer" <andreas.kretschmer@schollglas.com>
Дата:
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    ===

Copy of a schema

От:
Frederic Massot <frederic@juliana-multimedia.com>
Дата:
Hi,

I wonder whether it is possible to copy a schema with a postgreSQL 
command like "copy_schema schema_src schema_dest" ?

It would be interesting for the development and the tests to be able to 
work on a copy of a schema without having to make a dump of database and 
to insert it in a new database or a new schema.

Regards.
-- 
==============================================
|              FREDERIC MASSOT               |
|     http://www.juliana-multimedia.com      |
|   mailto:frederic@juliana-multimedia.com   |
===========================Debian=GNU/Linux===
FAQ