| From: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
|---|---|
| To: | Jay <jayps(at)addr(dot)com> |
| Cc: | <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: Database joins |
| Date: | 2002-09-09 15:44:09 |
| Message-ID: | 20020909084148.S13345-100000@megazone23.bigpanda.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
On Mon, 9 Sep 2002, Jay wrote:
> Hi,
> I have created two databases, db1 and db2 in my POSTGRESQL database system.
> And both the databases contains few tables also.
> Could you please help me to write a query which should retrieve data from both the databases
> (Database joins and table joins)
You cannot currently directly via sql only do
cross database joins. You might want to see
if contrib/dblink will let you do what you want
(iirc it's gotten better in 7.3 with the
functions returning result set stuff).
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Masaru Sugawara | 2002-09-09 16:23:29 | Re: the best way to get the topest 3 record in every group |
| Previous Message | Stephan Szabo | 2002-09-09 15:37:37 | Re: Character translation? |