Thread: Select from multiple DBs

Select from multiple DBs

From
"psql novice"
Date:
    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;

--
____________________________________________
http://www.operamail.com
Get OperaMail Premium today - USD 29.99/year


Powered by Outblaze


Re: Select from multiple DBs

From
Adam Witney
Date:
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.