Accessing other database... - Mailing list pgsql-sql

From Frederic boucher
Subject Accessing other database...
Date
Msg-id 19991104153657.40198.qmail@hotmail.com
Whole thread Raw
Responses Re: [SQL] Accessing other database...  (Stoyan Genov <genov@digsys.bg>)
List pgsql-sql
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


pgsql-sql by date:

Previous
From: Stoyan Genov
Date:
Subject: Re: [SQL] Optimizing a query through its syntax and indices
Next
From: "Zot O'Connor"
Date:
Subject: Tracking depth question