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: 2008-03-27 09:44:41
Message-ID: 47EB6C89.5050401@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Craig Ringer 2008-03-27 09:46:16 Re: returned value from SQL statement
Previous Message Harald Fuchs 2008-03-27 09:44:40 Re: Survey: renaming/removing script binaries (createdb, createuser...)