Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Using tables in other PostGreSQL database
- From: Richard Huxton <dev(at)archonet(dot)com>
- To: "Pettis, Barry" <Barry(dot)Pettis(at)atmel(dot)com>
- Cc: pgsql-general(at)postgresql(dot)org
- Subject: Re: Using tables in other PostGreSQL database
- Date: Thu, 27 Mar 2008 09:44:41 +0000
Pettis, Barry wrote:
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?
There is an add-on in contrib/ called "dblink" that lets you connect to a remote database. There's also a dbilink project that uses Perl.
Also to respond in the thread... Do I just reply to the message?
Reply-All is the default on the pg lists. -- Richard Huxton Archonet Ltd
- Follow-Ups:
- Re: Using tables in other PostGreSQL database
- From: Pettis, Barry
- Re: Using tables in other PostGreSQL database
- References:
- Using tables in other PostGreSQL database
- From: Pettis, Barry
- Using tables in other PostGreSQL database
- Prev by Date: returned value from SQL statement
- Next by Date: Re: Survey: renaming/removing script binaries (createdb, createuser...)
- Previous by thread: Using tables in other PostGreSQL database
- Next by thread: Re: Using tables in other PostGreSQL database
- Indexes: