Hi, Gregory, Gregory S. Williamson wrote: > A sodden late night idea ... schemas don't need to have names that > are meaningful to outsiders.
Yes, but having schema names like A34FZ37 not only qualifies for thedailywtf.com, but also tends to produce maintainance nightmares. And it still allows the customer to estimate the amount of customers. > Still, the point about "political" aspects is an important one. OTH, > schemas provide an elegant way of segregating data. Yes, they do, and in the ASP case (where we have control over all software that connects to PostgreSQL) we use the one schema per customer paradigm quite successfully. > My $0.02 (not worth what it was) Oh, I think the're at least $0.03 cents worth. :-) Markus -- Markus Schaber | Logical Tracking&Tracing International AG Dipl. Inf. | Software Development GIS Fight against software patents in EU! www.ffii.org www.nosoftwarepatents.org ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
