pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Cédric Villemain <cedric.villemain@dalibo.com>
To: pgsql-admin@postgresql.org
Cc: Spiegelberg, Greg <gspiegelberg@isodxsolutions.com>
Cc: gap.mailinglists@googlemail.com
Subject: Re: Copying schemas between databases
Date: Thu, 10 May 2007 15:43:42 +0200
Message-ID: <200705101543.48405.cedric.villemain@dalibo.com> (raw)
In-Reply-To: <82E74D266CB9B44390D3CCE44A781ED90B6B14@POSTOFFICE.cranel.local>
References: <82E74D266CB9B44390D3CCE44A781ED90B6B14@POSTOFFICE.cranel.local>

Le jeudi 10 mai 2007, Spiegelberg, Greg a écrit :
> 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



-- 
Cédric Villemain
Administrateur de Base de Données
Cel: +33 (0)6 74 15 56 53
http://dalibo.com - http://dalibo.org

view thread (4+ messages)

Message-ID: <200705101543.48405.cedric.villemain@dalibo.com>
Permalink:  ../200705101543.48405.cedric.villemain@dalibo.com/
Also on:    postgresql.org/message-id/200705101543.48405.cedric.villemain@dalibo.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: cedric.villemain@dalibo.com, gspiegelberg@isodxsolutions.com, gap.mailinglists@googlemail.com
  Subject: Re: Copying schemas between databases
  In-Reply-To: <200705101543.48405.cedric.villemain@dalibo.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox