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.



Thu, 25 Oct 2001 19:53:44 -0400
"Sean Sell" <sksell@mindspring.com>
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


Mon, 29 Oct 2001 14:48:06 -0500
"Serguei Mokhov" <sa_mokho@alcor.concordia.ca>
Re: Cross Database Links