Re: [GENERAL] Multiple database queries

2005-10-02 Thread Marc Andre Paquin
Le 2005 10 02 14:36, David Fetter a ecrit: > On Sat, Oct 01, 2005 at 09:37:49PM -0700, Cosmopo 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

Re: [GENERAL] Multiple database queries

2005-10-02 Thread David Fetter
On Sun, Oct 02, 2005 at 11:20:38PM -0400, Marc Andre Paquin wrote: > Le 2005 10 02 14:36, David Fetter a ecrit: > > On Sat, Oct 01, 2005 at 09:37:49PM -0700, Cosmopo wrote: > > > Hello, > > > > > > I was using many years ago Sybase that was able then to query > > > several tables that could be loca

Re: [GENERAL] Multiple database queries

2005-10-02 Thread David Fetter
On Sat, Oct 01, 2005 at 09:37:49PM -0700, Cosmopo 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

Re: [GENERAL] Multiple database queries

2005-10-02 Thread William ZHANG
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" <[EMAIL PROTECTED]> wrote > Hello, >

Re: [GENERAL] Multiple database queries

2005-10-02 Thread Andreas Kretschmer
Cosmopo <[EMAIL PROTECTED]> schrieb: > 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 I

[GENERAL] Multiple database queries

2005-10-02 Thread Cosmopo
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 c