From: Roberto Mello <rmello@cc.usu.edu>
To: peter <peter@peter.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: multiple databases
Date: Mon, 28 Oct 2002 07:21:31 -0700
Message-ID: <20021028142131.GC28332@cc.usu.edu> (raw)
In-Reply-To: <apdag4$14qj$1@news.hub.org>
References: <apdag4$14qj$1@news.hub.org>
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."
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: rmello@cc.usu.edu, peter@peter.com
Subject: Re: multiple databases
In-Reply-To: <20021028142131.GC28332@cc.usu.edu>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox