| From: | Pavel Stehule <stehule(at)kix(dot)fsv(dot)cvut(dot)cz> |
|---|---|
| To: | "K(dot) Deepa" <kdeepa(at)midascomm(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Accessing tables from different databases |
| Date: | 2003-09-24 15:10:37 |
| Message-ID: | Pine.LNX.4.44.0309241707170.4840-100000@kix.fsv.cvut.cz |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hello,
You can acces others db via dblink. You will find it in contrib.
You can't use dblink for define f.k. :-(
regars
Pavel
> Hi all,
> I want to access a table-1 of database-1 from
> database-2. Is it possible in pgsql. If so,
> is it possible to define a foreign key constraint
> for a column in table-2 in database-2 which
> references to a column in table-1 in database-1.
> TIA
>
> regards,
> Deepa K.
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Vivek Khera | 2003-09-24 15:14:00 | Re: State of Beta 2 |
| Previous Message | Stephan Szabo | 2003-09-24 14:53:35 | Re: Is this "order by" logic right |