Re: Separation of clients' data within a database

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