From: | Thomas Beutin <tyrone(at)laokoon(dot)IN-Berlin(dot)DE> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Accessing another db? |
Date: | 2002-06-18 14:26:10 |
Message-ID: | 20020618162610.C24882@laokoon.bug.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)laokoon(dot)IN-Berlin(dot)DE
Beam me up, Scotty. There is no intelligent live down in Redmond.
From | Date | Subject | |
---|---|---|---|
Next Message | Bjoern Metzdorf | 2002-06-18 14:28:11 | db grows and grows |
Previous Message | Bjoern Metzdorf | 2002-06-18 14:21:07 | Re: Help automate pg_dump |