Re: Accessing tables from different databases

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Fernando Schapachnik <fernando(at)mecon(dot)gov(dot)ar>
Cc: "K(dot) Deepa" <kdeepa(at)midascomm(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Accessing tables from different databases
Date: 2003-09-24 14:29:25
Message-ID: 3950.1064413765@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Fernando Schapachnik <fernando(at)mecon(dot)gov(dot)ar> writes:
> En un mensaje anterior, K. Deepa escribi:
>> I want to access a table-1 of database-1 from
>> database-2. Is it possible in pgsql. If so,

> Look at contrib/dblink.

Also consider the possibility of using multiple schemas in a single
database, rather than a multi-database installation.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Russ Brown 2003-09-24 14:35:17 pltcl problem
Previous Message Tom Lane 2003-09-24 14:28:31 Re: data directory growing huge