On Mon, 9 Sep 2002, Jay wrote: > Hi, > I have created two databases, db1 and db2 in my POSTGRESQL database system. > And both the databases contains few tables also. > Could you please help me to write a query which should retrieve data from both the >databases > (Database joins and table joins)
You cannot currently directly via sql only do cross database joins. You might want to see if contrib/dblink will let you do what you want (iirc it's gotten better in 7.3 with the functions returning result set stuff). ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
