Referring a table in another database

On Fri, 2 Nov 2001, Jo wrote:

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.

Not currently.

Jo <rainbow@linuxfocus.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

Hello,

That is correct. Currently within PostgreSQL tables are specific to
their database and can not cross-query. You will have to create all tables
within the database.

J

On Mon, 5 Nov 2001, Stephan Szabo wrote:

On Fri, 2 Nov 2001, Jo wrote:

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.

Not currently.

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

--
--
by way of pgsql-general@commandprompt.com
http://www.postgresql.info/
http://www.commandprompt.com/

At 21:42 02/11/01 +0100, you wrote:

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.

It is not possible before schema features are implemented (PostgreSQL 7.3?).
Maybe it is possible to run queries remotely using plperl, but I am not sure.

Best regards,
Jean-Michel POURE