Re: A simple question (under pressure :-))....

John Wells <jb@sourceillustrated.com> writes:

> Guys,
>
> I have approx. 8 hours to finish a deadline, so I can no longer spend time searching google...haven't found the
answeryet. 
>
> 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