On Sun, Nov 29, 2009 at 21:21, Ivan Sergio Borgonovo <mail@xxxxxxxxxxxxxxx> wrote: > I need to create a new schema with all the content in an existing > one, just with a new name. > > The way I've found is: > - make a backup > - load it in a dev box > - rename the schema > - make a backup of the new schema > - restore the new schema on the original DB. > > Is there a more efficient approach? Sadly no. With smaller DBs I do a sed on the dump ... wished there would be a restore with not only a target DB but also a target schema. -- ★ Clemens 呉 Schwaighofer ★ IT Engineer/Web Producer/Planning ★ E-Graphics Communications SP Digital ★ 6-17-2 Ginza Chuo-ku, Tokyo 104-8167, JAPAN ★ Tel: +81-(0)3-3545-7706 ★ Fax: +81-(0)3-3545-7343 ★ http://www.e-gra.co.jp This e-mail is intended only for the named person or entity to which it is addressed and contains valuable business information that is privileged, confidential and/or otherwise protected from disclosure. If you received this e-mail in error, any review, use, dissemination, distribution or copying of this e-mail is strictly prohibited. Please notify us immediately of the error via e-mail to disclaimer@xxxxxxxxxxxxx and please delete the e-mail from your system, retaining no copies in any media. We appreciate your cooperation. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
