Thread: Cross-database references

On Friday 28 February 2003 16:05, Sidar Lopez Cruz wrote:
> When i try to do something like
>
> templae1=# select * from mydatabase.public.mytale;
>
> this message appear: Cross-database references are not implemented

This is normal behaviour for Postgres. This syntax is not supported,
even if the database you are referencing is the current one.

See also:
  http://www.postgresql.org/docs/faqs/FAQ.html#4.24

Ian Barwick
barwick@gmx.net

Check out the dblink module in contrib

On Fri, 2003-02-28 at 10:05, Sidar Lopez Cruz wrote:
> When i try to do something like
>
> templae1=# select * from mydatabase.public.mytale;
>
> this message appear: Cross-database references are not implemented
>
>
> :-) Sidar Lopez Cruz
> - Cero Riesgo, S.A.

On Fri, 2003-02-28 at 16:05, Sidar Lopez Cruz wrote:
> When i try to do something like
>
> templae1=# select * from mydatabase.public.mytale;
>
> this message appear: Cross-database references are not implemented

This could be because cross-database references are not implemented (yet
:-) ... for now you'll have to have local data-sources (or use some
contrib module)

Cheers,
Tycho

--
Tycho Fruru                            tycho@fruru.com
"Prediction is extremely difficult. Especially about the future."
  - Niels Bohr