Re: [SQL] Multiple databases

Sumaya wrote: Hi, I am converting sql code from sql server to postgresql. Data is currently being retrieved from multiple databases, how do I do this using postgresql. I have tried using eg. select * from datbasename.tablename but this does not work. Any ideas? Thanks, Sumaya Are you

Re: [SQL] Multiple databases

am Wed, dem 16.04.2008, um 8:59:46 +0200 mailte Sumaya folgendes: > Hi, > > I am converting sql code from sql server to postgresql. Data is currently > being retrieved from multiple databases, how do I do this using postgresql. I > have tried using eg. select * from datbasename.tablename but

[SQL] Multiple databases

Hi, I am converting sql code from sql server to postgresql. Data is currently being retrieved from multiple databases, how do I do this using postgresql. I have tried using eg. select * from datbasename.tablename but this does not work. Any ideas? Thanks, Sumaya

Re: [SQL] multiple databases

On Sat, Oct 26, 2002 at 03:15:18PM +1000, peter wrote: > I need to create a recordset in vb which combines a view/table from 2 > different databases. Is this possible? in mssql you could go > dbo.databasename.tablename. Can it be done in vb code? There's an extension to PostgreSQL, called dblin

[SQL] multiple databases

I need to create a recordset in vb which combines a view/table from 2 different databases. Is this possible? in mssql you could go dbo.databasename.tablename. Can it be done in vb code? Thanks for any help Peter ---(end of broadcast)--- TIP 2:

Re: [SQL] Multiple Databases

thanks for your help guys. Peter "Joe Conway" <[EMAIL PROTECTED]> wrote in message news:3DB6D01C.9000601@;joeconway.com... > Josh Berkus wrote: > >>Is it possible to create a view using tables from two different > >>postgresql > >>servers? > > > > No. > > > > It isn't possible with plain old SQL

Re: [SQL] Multiple Databases

Josh Berkus wrote: Is it possible to create a view using tables from two different postgresql servers? No. It isn't possible with plain old SQL, but it is possible (albeit ugly) using contrib/dblink in PostgreSQL 7.2.x. See README.dblink for documentation and examples. In PostgreSQL 7.3 (i

Re: [SQL] Multiple Databases

Peter, > Is it possible to create a view using tables from two different > postgresql > servers? No. -Josh Berkus ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html

[SQL] Multiple Databases

Is it possible to create a view using tables from two different postgresql servers? Thanks Peter ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]