Re: Multiple database queries - Mailing list pgsql-general

From William ZHANG
Subject Re: Multiple database queries
Date
Msg-id dhongg$i0n$2@news.hub.org
Whole thread Raw
In response to Multiple database queries  ("Cosmopo" <tempo@marquo.com>)
List pgsql-general
Sybase and Microsoft SQL Server are  somewhat silimar on
the concept `database'. They both support queries across
multiple databases. But pgsql's database is different,
I think you can use pgsql's schemas to cope with problem.

Regards, William ZHANG

"Cosmopo" <tempo@marquo.com> wrote
> Hello,
>
> I was using many years ago Sybase that was able then to query several
> tables that could be located in more than one database... I know that
> Postgresql did not at the time have this capability.
>
> Does the new version 8.0.x ofter this feature? We need to create
> several databases based on our customer's specs... but we need our own
> customer, permission, history, etc database. We want to be able to
> query 2 database that would have share customer's ID and other info.
>
> If not, what is the best workaround?
> Thank's to all.
> Mark
>



pgsql-general by date:

Previous
From: "William ZHANG"
Date:
Subject: Re: 8.1 'make check' fails
Next
From: Ben-Nes Yonatan
Date:
Subject: Re: Broken pipe