Using tables in other PostGreSQL database - Mailing list pgsql-general

From Pettis, Barry
Subject Using tables in other PostGreSQL database
Date
Msg-id C6471264338047459F18230B4F871DA0010E9B11@csomb01.corp.atmel.com
Whole thread Raw
Responses Re: Using tables in other PostGreSQL database  (Richard Huxton <dev@archonet.com>)
List pgsql-general
I work at a fairly large company 2000 people just at my site alone.
I've been given access to a new database which will be used for source
data for some software that the company just purchased.

Now this PostGreSQL "server" has many databases in it.  Some of which I
have access to.  I don't want to reinvent the wheel ( so to speak ) by
having to replicate the table in my database.  Then having to create
routines that will extract from A to replicate in B.  How do I reference
a table in another database?

The other user all ready updates and adds important information so I
don't want to have to replicate his/her work.  I just want to purloin
his finished product... Though I think that that's the whole point.



Also to respond in the thread... Do I just reply to the message?

Regards,
Barry Pettis





























http://www.ozgrid.com/forum/misc.php?do=getsmilies&editorid=vB_Editor_00
1


pgsql-general by date:

Previous
From: Daniel Nauck
Date:
Subject: Re: [Mono-list] NauckIT PostgreSQL provider working with Mono?
Next
From: srdjan
Date:
Subject: Re: RULES and QUALIFICATION for INSERT