Re: cross database references...

From: Scott Marlowe <smarlowe(at)g2switchworks(dot)com>
To: Jessica Richard <rjessil(at)yahoo(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: cross database references...
Date: 2007-05-18 15:59:07
Message-ID: 464DCD4B.6030904@g2switchworks.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Abu Mushayeed 2007-05-18 16:00:06 CPU Intensive query
Previous Message Brian A. Seklecki 2007-05-18 15:55:11 Re: Frequent pg_clog on system