Foreign Key between different databases

From: "Stan van de Mortel" <SvdMortel(at)InterPlein(dot)nl>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: Foreign Key between different databases
Date: 2001-04-10 08:53:13
Message-ID: 000001c0c19b$af7b5100$5102a8c0@stanlp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hello,

I've a table in a database and I want to create a column that is a foreign
key to a table in an other database. When I try ...,foreign key (x)
references otherdb.table(x) it says 'parse error at or near "."'.

Is there an other way to create this kind of foreign key?

Stan van de Mortel
[SvdMortel(at)InterPlein(dot)nl]

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Michael Ansley 2001-04-10 09:30:22 RE: Sorting and then...
Previous Message Jaruwan Laongmal 2001-04-10 08:14:32 problem with copy command