Cross Database Shared Tables?

From: Mitch Vincent <mitch(at)karboneye(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Cross Database Shared Tables?
Date: 2003-03-24 17:42:19
Message-ID: F5CBB5C5-5E1F-11D7-BF96-0003938024CA@karboneye.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I know this has probably been asked before but the archive searching
seems to just hang for me..

I'm in a situation trying to teach an old application new tricks. I
have a table in one database that I need to be shared across several
other databases ( to do joins against it etc). Is it possible to do
this now with schemas, or am I out of luck?

Also, can a function/trigger access another database to perform queries
there instead of in the database where the trigger/function is created?

Thanks very much!

-Mitch

Responses

Browse pgsql-general by date

  From Date Subject
Next Message scott.marlowe 2003-03-24 18:01:01 Re: postmaster has high CPU (system) utilization
Previous Message Bruce Momjian 2003-03-24 17:27:31 Re: alter table change type column