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 === ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
