select across two databases

Поиск
Список
Период
Сортировка
От The Hermit Hacker
Тема select across two databases
Дата
Msg-id Pine.BSF.3.96.980527080241.301E-100000@hub.org
обсуждение исходный текст
Список pgsql-sql

hi,

when I have two databases say db1 and db2 can there be a select
statement which accesses both databases eg.

select * from db1.t1,db2.t2 (which is illegal syntax in postgresql but
legal in informix)

Is there another way to select several databases/namespaces at once?


Dirk


В списке pgsql-sql по дате отправления: