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.
It seems I've been able to do this in the past, but I may be remembering wrong.
pgsql-general by date
|Next:||From: Doug McNaught||Date: 2004-03-01 02:07:36|
|Subject: Re: A simple question (under pressure :-))....|
|Previous:||From: Uwe C. Schroeder||Date: 2004-03-01 01:33:11|
|Subject: Re: count(1) return 0?|