Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 79C6947673D
	for <pgsql-sql@postgresql.org>; Mon, 28 Oct 2002 09:12:47 -0500 (EST)
Received: from brasileiro.net (slxwy.dorms.usu.edu [129.123.227.56])
	by postgresql.org (Postfix) with ESMTP id 8590C476E35
	for <pgsql-sql@postgresql.org>; Mon, 28 Oct 2002 09:11:50 -0500 (EST)
Received: from roberto by brasileiro.net with local (Exim 3.35 #1 (Debian))
	id 186Aln-0007OW-00; Mon, 28 Oct 2002 07:21:31 -0700
Date: Mon, 28 Oct 2002 07:21:31 -0700
From: Roberto Mello <rmello@cc.usu.edu>
To: peter <peter@peter.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: multiple databases
Message-ID: <20021028142131.GC28332@cc.usu.edu>
References: <apdag4$14qj$1@news.hub.org>
Mime-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Disposition: inline
In-Reply-To: <apdag4$14qj$1@news.hub.org>
User-Agent: Mutt/1.4i
X-message-flag: Please consider using an e-mail program other than Outlook.
	It's insecure.
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200210/377
X-Sequence-Number: 10094

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 dblink, that allows it. Look at
the contrib tree on the PostgreSQL archives.

-Roberto

-- 
+----|        Roberto Mello   -    http://www.brasileiro.net/  |------+
+       Computer Science Graduate Student, Utah State University      +
+       USU Free Software & GNU/Linux Club - http://fslc.usu.edu/     +
"Data! I thought you were dead!" "No, Sir. I rebooted."