Re: [SQL] Accessing other database...

I'll probably have to do something like that... But the table will still
contains the data off all the users. Since, unlike my first example, there
will be a lot more than 2 users, the action (update,select,add,delete) will
be much slower than if only the good records would be in the table. if I do
something like :

delete from TheTable;

or

delete from TheTable where User_ID = THE_ID

the first will be faster even with an index on UserID. And deleting all
data is a "simple" action... I'm not talking about more complicated
actions.

\fb

Thanks for your help and if you have an other idea... don't hesitate!

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

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