Re: Cross database reference (databases are on the same

But keeping two databases, allows you to have to physical space (data
directory) ...
Sort of a replication benefit...

scott.marlowe wrote:

>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.
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 6: Have you searched our list archives?
>
>http://archives.postgresql.org
>
>