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
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
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 an
