Skip site navigation (1) Skip section navigation (2)

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

From: John Wells <jb(at)sourceillustrated(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: A simple question (under pressure :-))....
Date: 2004-03-01 01:37:52
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-general

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 McNaughtDate: 2004-03-01 02:07:36
Subject: Re: A simple question (under pressure :-))....
Previous:From: Uwe C. SchroederDate: 2004-03-01 01:33:11
Subject: Re: count(1) return 0?

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group