Re: Referring a table in another database

From: Doug McNaught <doug(at)wireboard(dot)com>
To: Jo <rainbow(at)linuxfocus(dot)org>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Referring a table in another database
Date: 2001-11-05 17:46:40
Message-ID: m3lmhlrtz3.fsf@belphigor.mcnaught.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Jo <rainbow(at)linuxfocus(dot)org> writes:

> Hi,
>
> Is it possible to make a reference to a table in another database in
> PostgreSQL? I know I can do that in Access. If it's not possible I have to
> make all of my tables in 1 database.

No, you currently can't do this. It's being discussed as a feature
(SQL-standard schemas) in the next version (after 7.2 which is
currently in beta).

-Doug
--
Let us cross over the river, and rest under the shade of the trees.
--T. J. Jackson, 1863

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2001-11-05 17:53:27 Re: Define update-rule on view
Previous Message lluong 2001-11-05 17:39:54 pg_restore