Happiness is a cross database link...

From: Alex Turner <armtuk(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Happiness is a cross database link...
Date: 2005-01-06 00:23:59
Message-ID: 33c6269f05010516231471eac3@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I am trying to find out some information on how to set up a cross
database links so that I can have queries and foreign keys that cross
a physical database. This is not just a technical requirement, but a
legal one (The client requires that we do not co-mingle data). I have
a new database that has tables and indices named using a new naming
schema, and an old database that was implemented based on a customer
requirement that is ugly, and I don't really want to put everything
into one database (technical reason). I have read that contrib/dblink
can do this, but I am unable to find any documentation for this
features, or infact any documentation on what is in the 'contrib'
pacakge. Can anyone point me to a good place to find contrib docs, or
and point me to database cross linking stuff. My boss will be really
pissed if I tell him we need to spend $10k to implement Oracle to have
a good solution ;)

Thanks,

Alex Turner
NetEconomist

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Marc G. Fournier 2005-01-06 01:26:51 Re: Happiness is a cross database link...
Previous Message Michael Fuhr 2005-01-06 00:07:10 Re: Trigger Question