Re: Select from different database - Mailing list pgsql-general

> Jacob Vennervald Madsen writes:
>
> > Is it possible to fetch data from another database than the current?
>
> No.

New FAQ item:

    <H4><A href="#4.25">4.25</A>) How do I perform queries
    using multiple databases?<H4>

    <P>There is no way to query any database except the current one.
    Because PostgreSQL loads database-specific system catalogs, it is
    uncertain how a cross-database query should even behave.</P>

    <P>Of course, a client can make simultaneous connections to
    different databases and merge the information that way.</P>

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026