PostgreSQL - Mailing list pgsql-general

From Camarao, Wagner (v)
Subject PostgreSQL
Date
Msg-id 6849495BC0DED61188D500080245C6D1A3723C@exchange-rio.bowneglobal.com.br
Whole thread Raw
List pgsql-general
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


pgsql-general by date:

Previous
From: jwsacksteder@ramprecision.com
Date:
Subject: Re: temporary table oddity
Next
From: "Chris Smith"
Date:
Subject: Please help with this error message