Thread: Accessing other database...

Is it possible to acess another database from a database..?  Like SHEMA in 
oracle?  Because, otherwise it meens that all my users should use the same 
database and see (without being able to select) the others tables, 
views,etc..

I've tried something like :

select * from databasename.tablename;

but...  it does not work...  is there a way around to do this?


______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com

Hello,

It is NOT possible to access another database from a database.
Is the case so specific that you cannot create different databases for the
different groups of users? Doing this, you can fairly easy regulate users'
access to databases through GRANT/REVOKE and pg_hba.conf

Stoyan Genov