Re: Using tables in other PostGreSQL database

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