PDA

View Full Version : Selecting Data from a different database than you current one


dwilliams
09-30-02, 12:42
If I am in database A and want to query data from database B what database notation do I use? I cannot seem to find a reference for this.

In MSSQL it is databasename.dbo.table

thanks

Dave

eperich
10-03-02, 07:41
I think what you need is dblink.

You want to make joins through databases.
It's in the contrib of postgres