| From: | Roberto Mello <rmello(at)cc(dot)usu(dot)edu> |
|---|---|
| To: | Tiago Moitinho <tmoitinho(at)hotmail(dot)com> |
| Cc: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: Select table from other database |
| Date: | 2002-10-21 14:21:57 |
| Message-ID: | 20021021142156.GB13464@cc.usu.edu |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
On Mon, Oct 21, 2002 at 11:54:53AM +0100, Tiago Moitinho wrote:
> Hi,
>
> I would like to know if this is possible:
>
> I have a database A, with a table X.
> Is it possible, being logged in another database (B, for instance), to make
> queries using table X from database A?
> (something like "SELECT * FROM A.X ...")
See the dblink module in the PostgreSQL contrib tree (available via ftp.
packages available).
-Roberto
--
+----| Roberto Mello - http://www.brasileiro.net/ |------+
+ Computer Science Graduate Student, Utah State University +
+ USU Free Software & GNU/Linux Club - http://fslc.usu.edu/ +
Sigh. I like to think it's just the Linux people who want to be on
the "leading edge" so bad they walk right off the precipice.
-- Craig E. Groeschel
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Josh Berkus | 2002-10-21 15:46:02 | Re: isAutoIncrement and Postgres |
| Previous Message | Jadcharla Srinivas | 2002-10-21 13:41:44 | Finding table constraints |