Re: Separation of clients' data within a database

[John McCawley <nospam@xxxxxxxxxxxx>]

It seems that this approach would suffer the same problem as the one I 
outlined in "1) Actually separate client data by table".  I would have 
to modify the logic of my web app...My web app currently handles all of 
the data, regardless of company, so it would have to aggregate the data 
from the different schemas when pulling data, and be smart enough to 
write back to the proper schemas when writing data.

Leonel Nunez wrote:

> why don't you create a  schema for every company and grant permissions to
> use the shchema to only the user that needs to use that??
>
> more info :
> http://www.postgresql.org/docs/8.1/static/ddl-schemas.html
>
>
> Leonel
>
>
>