Re: Accessing another db?

On Tue, Jun 18, 2002 at 03:57:20PM +1000, Graeme Merrall wrote:
> After browsing through the archives and coming up nix I was wondering if
> it's possoble for a user to query the tables in another database. Coming
> from an Oracle background  it's possible to use "SELECT column1 FROM
> user.table" but I can't seem to find if this is possible in postgres
AFAIK every database has its own tables - and cannot see other databases
tables.

In pgsql You can change to another database with the command
\connect <database_name>


> I've read some discussion from April 2002 which infers that that
> functionality doesn't exist but it's coming in 7.3. Correct?
I don't know, sorry.

greetz
-tb
--
Thomas Beutin                             tb@laokoon.IN-Berlin.DE
Beam me up, Scotty. There is no intelligent live down in Redmond.