John Wells <[EMAIL PROTECTED]> writes: > Guys, > > I have approx. 8 hours to finish a deadline, so I can no longer spend time searching > google...haven't found the answer yet. > > In PG, is there not a way to select amongst databases? > > In other words, if I have one schema called sch1 and another called sch2, and I'm > connected to sch2, could I not do: > > select fieldname from sch1.tablename > > I'm running 7.2.3, so I think there was no such things as a schema in this > release...just a database, but can't recall.
Right. Schemas went into 7.3. You can try 'contrib/dblink' for cross-database queries in earlier versions--it might or might not work for you (I've never used it myself). > It seems I've been able to do this in the past, but I may be > remembering wrong. Maybe that was with 7.3 or 7.4? -Doug ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match