Thread: Cross Database Links

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.

----- 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