Re: Select from multiple DBs

From: Adam Witney <awitney(at)sghms(dot)ac(dot)uk>
To: psql novice <psql_novice(at)operamail(dot)com>, pgsql-novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Select from multiple DBs
Date: 2003-05-05 10:16:48
Message-ID: BADBF8A0.18301%a.witney@sghms.ac.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice


Although I have never used it myself, I believe dblink in contrib/ will do
this

adam

> Is it possible to select from multiple databases in one go??
>
> lets say you had 2 databases called 'a' and 'b':
>
> select * from a.users, b.users;
>

--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Divya Ramgopal 2003-05-05 10:54:10 TRIGGERS
Previous Message paul butler 2003-05-05 09:40:37 Re: Application Development with PostgreSQL