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

Hi John,

Short answer: you can do cross-schema queries, you can't (easily) do
cross database queries.

Check out this:
http://www.postgresql.org/docs/7.4/static/ddl.html
, the schema section:
http://www.postgresql.org/docs/7.4/static/ddl-schemas.html

I'm not sure when schemas were introduced, but I suppose you want to use
the latest postgres version.

Cheers,
Csaba.

On Mon, 2004-03-01 at 02:37, John Wells wrote:
> 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.  
>
> It seems I've been able to do this in the past, but I may be remembering wrong.
>
> Thanks!
> John
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
>                http://www.postgresql.org/docs/faqs/FAQ.html