Cross Database Links

Started by Sean Sellabout 24 years ago2 messages
#1Sean Sell
sksell@mindspring.com

I think I read somewhere that you CANNOT access a table view etc. in another
database.
I wanted to confirm that this was the case or see if there was a method
(hack) to create
an alias to another database.

For example:

psql foo
foo# CREATE VIEW v1 AS SELECT * FROM BAR.t1;

where BAR is another database (same PostgreSQL server).

I was also wondering what the correct method is for restircting users
ability to
create tables, views etc.

#2Serguei Mokhov
sa_mokho@alcor.concordia.ca
In reply to: Sean Sell (#1)
Re: Cross Database Links

----- Original Message -----
From: Sean Sell <sksell@mindspring.com>
Sent: Thursday, October 25, 2001 6:53 PM

I think I read somewhere that you CANNOT access a table view etc. in another
database.
I wanted to confirm that this was the case or see if there was a method
(hack) to create
an alias to another database.

As I said before this will possible when schemas are implemented.

-s