Accessing other database...

From: "Frederic boucher" <dziablo(at)hotmail(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Accessing other database...
Date: 1999-11-04 07:36:56
Message-ID: 19991104153657.40198.qmail@hotmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-sql by date

  From Date Subject
Next Message Stoyan Genov 1999-11-04 12:59:03 Re: [SQL] Optimizing a query through its syntax and indices
Previous Message Hamid Khoshnevis 1999-11-04 05:54:33 Copying databases