Search Postgresql Archives

Re: Any Plans for cross database queries on the same server?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Tue, Jan 30, 2007 at 06:15:01PM -0800, Joshua D. Drake wrote:
> Peter Eisentraut wrote:
> >This has been discussed about ten thousand times, and the answer is
> >still no.
> >  
> Actually the answer is: Check the TODO list. It is listed under
> Exotic features, so the answer is, no we can't yes we would like to.
> 
> That being said, I think it is a dumb feature. If you have data in
> one database, that requires access to another database within the
> same cluster. You designed your database incorrectly and should be
> using schemas.
> 
> If you have data in one database that requires access to another
> database that is not in the same cluster (which happens alot) use
> dbi-link.

Thanks for the pointer, but you only need DBI-Link
<http://pgfoundry.org/projects/dbi-link/>, and I only recommend it, if
you need data from a non-PostgreSQL data source.

For a PostgreSQL data source, use Joe Conway's excellent contrib/dblink.

Cheers,
D
-- 
David Fetter <david@xxxxxxxxxx> http://fetter.org/
phone: +1 415 235 3778        AIM: dfetter666
                              Skype: davidfetter

Remember to vote!


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux