Re: [SQL] Accessing other database...

One thing you might want to do is to create the first (shared) table as you
do now. For the second table (different info for each user), create the
table as you planned but add a column to identify the user. You can then
create a view on this second table to filter out rows based on the user's
login id, so they will only see their own records.

Will this work for your application?

Jim Seach

-----Original Message-----
From: Frederic boucher <dziablo(at)hotmail(dot)com>
To: pgsql-sql(at)postgreSQL(dot)org <pgsql-sql(at)postgreSQL(dot)org>
Date: Friday, November 05, 1999 8:30 AM
Subject: Re: [SQL] Accessing other database...

>Ok so what can I do if I would like 2 user to have two tables. The first
>tabl would be a common table for both user (with the same synch data) and
>the other one would be the same "table_name" but each user would see
>different records?
>
>is this kind of thing possible?
>
>\fb
>
>Thanks
>>In-reply-to: Your message of "Thu, 04 Nov 1999 07:36:56 PST."
>><19991104153657(dot)40198(dot)qmail(at)hotmail(dot)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
>>
>
>______________________________________________________
>Get Your Private, Free Email at http://www.hotmail.com
>
>************
>