Postgres Pro
Downloads
Home   >   mailing lists

Linking 2 or more databases. - Mailing list pgsql-general

From Leif Jensen
Subject Linking 2 or more databases.
Date
Msg-id Pine.LNX.4.21.0210221635360.26645-100000@samba.crysberg.dk
Whole thread Raw
Responses Re: Linking 2 or more databases.  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-general
Tree view 
    Hi All,

  I need to get information from 2 (or more) database preferably in one
select statement. Is there a way to join tables from different databases
in the same SQL ? Can I have a 'virtual' foreign key ? Can I make a view
'cross database' ? Can I make some server side programming to accomplish
this task ? Where do I find documentation if any ?

  Thanks for any ideas,

 Leif

pgsql-general by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: Hot Backup
Next
From: Tom Lane
Date:
Subject: Re: IpcMemoryCreate: shmget(key=5432001, size=1441792, 03600) failed: Not enough memory