| From: | Doug McNaught <doug(at)mcnaught(dot)org> |
|---|---|
| To: | John Wells <jb(at)sourceillustrated(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: A simple question (under pressure :-)).... |
| Date: | 2004-03-01 02:07:36 |
| Message-ID: | 873c8t2uc7.fsf@asmodeus.mcnaught.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
John Wells <jb(at)sourceillustrated(dot)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 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Klint Gore | 2004-03-01 02:12:12 | Re: count(1) return 0? |
| Previous Message | John Wells | 2004-03-01 01:37:52 | A simple question (under pressure :-)).... |