Обсуждение: PostgreSQL

Поиск
Список
Период
Сортировка

PostgreSQL

От
"Camarao, Wagner (v)"
Дата:
Hello there, I hope I can count on your help.

    Is it possible to referes to a table from an external database in
the same server while executing a command?

    Suppose I am connected to my databaseA and I want to get some data
from databaseB (on the same server). Should I do something like:

    insert into tableA (select * from databaseB.tableB);

    like [dbo]. in MS SQL Server??

Thank's,

    ___________________________________
    Wagner Camarão, Developer
    Bowne Global Solutions

    Phone     +55 21 2515-7830
    Mobile    +55 21 8856-8568
    wagner.camarao@bowneglobal.com.br
    www.bowneglobal.com.br