Thread: Joining Between Databases

Myself along with a couple of co-workers have been searching for a way to
join tables from two postgres database. So far there are no indication that
this is possible, can someone shed some light on this subject.

(P.S We are attemping to do this in the same database instance)

Michael Williams

> Myself along with a couple of co-workers have been searching for a way to
> join tables from two postgres database. So far there are no indication that
> this is possible, can someone shed some light on this subject.
>
> (P.S We are attemping to do this in the same database instance)

The current snapshot code has /contrib/dblink utility that may help.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

I join tables from different databases using other
products such as MS Access.  I simply link the
PostgreSQL tables from different databases to the
Access file via ODBC and join the tables in the QBE
(Query By Example) window.  In fact, I used MS Access
as an intermediary to move data from MySQL to
PostgreSQL.

You can also do this with Paradox, Lotus Approach and
(I think) Perl DBI.

I don't know of any way to do this from within psql.

Best of luck,

Andrew

--- mwilliams <mwilliams@cardcommerce.com> wrote:
> Myself along with a couple of co-workers have been
> searching for a way to
> join tables from two postgres database. So far there
> are no indication that
> this is possible, can someone shed some light on
> this subject.
>
> (P.S We are attemping to do this in the same
> database instance)
>
> Michael Williams
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org


__________________________________________________
Do You Yahoo!?
Make a great connection at Yahoo! Personals.
http://personals.yahoo.com