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

From Richard Huxton
Subject Re: Using tables in other PostGreSQL database
Date
Msg-id 47EB6C89.5050401@archonet.com
Whole thread Raw
In response to Using tables in other PostGreSQL database  ("Pettis, Barry" <Barry.Pettis@atmel.com>)
Responses Re: Using tables in other PostGreSQL database  ("Pettis, Barry" <Barry.Pettis@atmel.com>)
List pgsql-general
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

pgsql-general by date:

Previous
From: "Alain Roger"
Date:
Subject: returned value from SQL statement
Next
From: Harald Fuchs
Date:
Subject: Re: Survey: renaming/removing script binaries (createdb, createuser...)