Re: cross database references... - Mailing list pgsql-admin

From Scott Marlowe
Subject Re: cross database references...
Date
Msg-id 464DCD4B.6030904@g2switchworks.com
Whole thread Raw
In response to cross database references...  (Jessica Richard <rjessil@yahoo.com>)
Responses Re: cross database references...  (Jessica Richard <rjessil@yahoo.com>)
List pgsql-admin
Jessica Richard wrote:
> Other than dblink, is there any other way to let me joint select two
> tables in two different databases?

Would schemas work for you?  You can have multiple schemas in one
database (like oracle) so that you references tables as
schemaname.tablename etc...  Works well for most places you need to do this.

pgsql-admin by date:

Previous
From: Stephane Bailliez
Date:
Subject: Re: Frequent pg_clog on system
Next
From: Abu Mushayeed
Date:
Subject: CPU Intensive query