On Sep 23, 2007, at 11:56 PM, Erik Jones wrote:
On Sep 21, 2007, at 6:16 PM, Stefan Arentz wrote:
Well I'm just toying with an idea. The problem I'm facing is that I
would like clients to only see the tuples that they have created and
own. I guess I'll just skip direct sql access to the db and write
some
API on top of it that manages the data. Not a big deal but it
complicates things :-)
You could do the same thing with views on those tables. One
problem with multiple databases is keeping global meta data for all
of your customers together in a simple way.
Oh, yeah, I forgot to mention separate schemas as well.
Erik Jones
Software Developer | Emma®
[EMAIL PROTECTED]
800.595.4401 or 615.292.5888
615.292.0777 (fax)
Emma helps organizations everywhere communicate & market in style.
Visit us online at http://www.myemma.com
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
