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." ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
