Re: Cross database reference (databases are on the same

On Tue, 8 Apr 2003, Flower Sun wrote:

>
> Hi, group,
>
> I didn't find a syntax for:
>
> select * from database1.tablename; -- while I am login in database2.
>
> Note: database1 and database2 are on one server (one database cluster).

There are two ways to do what you want.  One is the use dblink in the
contrib directory, which will let you basically do this.

the other is to move your two databases into one database with seperate
schemas, which is the preferred method and will usually result in much
faster queries.

Note that schema support is relatively new (came out in 7.3) so you might
have to update your postgrsql server to use them, but they are well worth
the effort of upgrading to have.