pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Copying schemas between databases
4+ messages / 4 participants
[nested] [flat]

* Copying schemas between databases
@ 2007-05-09 14:00  gap.mailinglists@googlemail.com
  0 siblings, 2 replies; 4+ messages in thread

From: gap.mailinglists@googlemail.com @ 2007-05-09 14:00 UTC (permalink / raw)
  To: pgsql-admin

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

^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Copying schemas between databases
@ 2007-05-10 13:02  Spiegelberg, Greg <gspiegelberg@isodxsolutions.com>
  parent: gap.mailinglists@googlemail.com
  1 sibling, 1 reply; 4+ messages in thread

From: Spiegelberg, Greg @ 2007-05-10 13:02 UTC (permalink / raw)
  To: gap.mailinglists@googlemail.com; pgsql-admin

See contrib/dblink.  It may be able to help.
 


________________________________

	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
	
	
	

^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Copying schemas between databases
@ 2007-05-10 13:21  Igor Neyman <ineyman@perceptron.com>
  parent: gap.mailinglists@googlemail.com
  1 sibling, 0 replies; 4+ messages in thread

From: Igor Neyman @ 2007-05-10 13:21 UTC (permalink / raw)
  To: gap.mailinglists@googlemail.com; pgsql-admin

Lookup "dblink" in postgres documentation.
 
Igor

________________________________

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

^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Copying schemas between databases
@ 2007-05-10 13:43  Cédric Villemain <cedric.villemain@dalibo.com>
  parent: Spiegelberg, Greg <gspiegelberg@isodxsolutions.com>
  0 siblings, 0 replies; 4+ messages in thread

From: Cédric Villemain @ 2007-05-10 13:43 UTC (permalink / raw)
  To: pgsql-admin; +Cc: Spiegelberg, Greg <gspiegelberg@isodxsolutions.com>; gap.mailinglists@googlemail.com

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

^ permalink  raw  reply  [nested|flat] 4+ messages in thread


end of thread, other threads:[~2007-05-10 13:43 UTC | newest]

Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-05-09 14:00 Copying schemas between databases gap.mailinglists@googlemail.com
2007-05-10 13:02 ` Spiegelberg, Greg <gspiegelberg@isodxsolutions.com>
2007-05-10 13:43   ` Cédric Villemain <cedric.villemain@dalibo.com>
2007-05-10 13:21 ` Igor Neyman <ineyman@perceptron.com>

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