| From: | Roberto Mello <rmello(at)cc(dot)usu(dot)edu> |
|---|---|
| To: | peter <peter(at)peter(dot)com> |
| Cc: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: multiple databases |
| Date: | 2002-10-28 14:21:31 |
| Message-ID: | 20021028142131.GC28332@cc.usu.edu |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
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."
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Roberto Mello | 2002-10-28 14:21:50 | Re: CoreReader |
| Previous Message | Christoph Haller | 2002-10-28 12:27:18 | Re: Accumulated sums in SQL query |