search_path="$user" in postgresql.conf
and you create one schema for each user with the user name as name....
Rodrigo
John McCawley wrote:
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
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
