| From: | "Shridhar Daithankar" <shridhar_daithankar(at)persistent(dot)co(dot)in> |
|---|---|
| To: | "pgsql-general" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: two databases |
| Date: | 2002-09-26 10:23:50 |
| Message-ID: | 3D932D8E.12148.139DD2CA@localhost |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 26 Sep 2002 at 12:19, mourad_dhambri wrote:
> I am creating a query in a database db1 that retrieves data from another database db2.
> How can I do this in PostGres?
> In Oracle I can write "select * from db2.table1.field1".
You can use dblink function in contrib that allows you to create database links
just like oracle..(OK may not be comparable but still..)
HTH
Bye
Shridhar
--
"How should I know if it works? That's what beta testers are for. I onlycoded
it."(Attributed to Linus Torvalds, somewhere in a posting)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tino Wildenhain | 2002-09-26 11:25:25 | Re: Adding "on delete cascade" after table creation ? |
| Previous Message | mourad_dhambri | 2002-09-26 10:19:49 | two databases |