Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 49F0D9FB58E for ; Thu, 10 May 2007 11:08:29 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 82795-06 for ; Thu, 10 May 2007 11:08:18 -0300 (ADT) X-Greylist: delayed 00:24:49.403843 by SQLgrey-1.7.5 Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 346719FB4B4 for ; Thu, 10 May 2007 11:08:23 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 Received: from achille.dalibo.net (achille.dalibo.net [212.85.153.230]) by svr4.postgresql.org (Postfix) with ESMTP id 5E4B85AF027 for ; Thu, 10 May 2007 13:43:33 +0000 (GMT) Received: from localhost (localhost.localdomain [127.0.0.1]) by achille.dalibo.net (Postfix) with ESMTP id BC65B7136B; Thu, 10 May 2007 15:43:22 +0200 (CEST) Received: from achille.dalibo.net ([127.0.0.1]) by localhost (achille [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 11840-06; Thu, 10 May 2007 15:43:22 +0200 (CEST) Received: from cedric-laptop.local (AToulouse-152-1-69-85.w83-200.abo.wanadoo.fr [83.200.233.85]) by achille.dalibo.net (Postfix) with ESMTP id E133362CF5; Thu, 10 May 2007 15:43:21 +0200 (CEST) From: =?iso-8859-15?q?C=E9dric_Villemain?= To: pgsql-admin@postgresql.org Subject: Re: Copying schemas between databases Date: Thu, 10 May 2007 15:43:42 +0200 User-Agent: KMail/1.9.6 Cc: "Spiegelberg, Greg" , gap.mailinglists@googlemail.com References: <82E74D266CB9B44390D3CCE44A781ED90B6B14@POSTOFFICE.cranel.local> In-Reply-To: <82E74D266CB9B44390D3CCE44A781ED90B6B14@POSTOFFICE.cranel.local> Organization: dalibo.com MIME-Version: 1.0 Content-Type: multipart/signed; boundary="nextPart1858096.8ivihiVeXs"; protocol="application/pgp-signature"; micalg=pgp-sha1 Content-Transfer-Encoding: 7bit Message-Id: <200705101543.48405.cedric.villemain@dalibo.com> X-Virus-Scanned: by amavisd-new-20030616-p10 (Debian) at dalibo.com X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.136 tagged_above=0 required=5 tests=BAYES_50=0.001, FORGED_RCVD_HELO=0.135 X-Spam-Level: X-Archive-Number: 200705/80 X-Sequence-Number: 25400 --nextPart1858096.8ivihiVeXs Content-Type: text/plain; charset="iso-8859-15" Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Le jeudi 10 mai 2007, Spiegelberg, Greg a =E9crit=A0: > See contrib/dblink. It may be able to help. you can also have a look at : https://developer.skype.com/SkypeGarage/DbProjects/PlProxy > > > > ________________________________ > > From: pgsql-admin-owner@postgresql.org > [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of > gap.mailinglists@googlemail.com > Sent: Wednesday, May 09, 2007 10:00 AM > To: pgsql-admin@postgresql.org > Subject: [ADMIN] Copying schemas between databases > > > > Hi > > Im using postgresql 8.2 > > I need to access data accross databases, I believe this is not > possible in Postgre. So my only alternative appears to be copying data, > the whole public schema, from one database to another. > > For example, i have a reporting database and several other > databases i would like to report on. I need to copy my public schemas > from the original databases to the reporting database and rename them > like so: > > MyFirstDatabase.public > ReportingDatabase.firstdb > OtherDatabase > ReportingDatabase.otherdb > > What is the easiest way to accomplish this? Or am i wrong in > thinking i cannot access adta directly accross databases? > > Any help much apperciated. > > thanks gp =2D-=20 C=E9dric Villemain Administrateur de Base de Donn=E9es Cel: +33 (0)6 74 15 56 53 http://dalibo.com - http://dalibo.org --nextPart1858096.8ivihiVeXs Content-Type: application/pgp-signature -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQBGQyGUo/dppWjpEvwRAqqoAKDecW/+ZhroKMfVL2yCgsrHMP+dMACgnD9T +sMoBXOkQ1vAN2HULG6r7E4= =0Num -----END PGP SIGNATURE----- --nextPart1858096.8ivihiVeXs--