| From: | "William Harazim" <wharazim(at)fulcoinc(dot)com> |
|---|---|
| To: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | Design question |
| Date: | 2005-07-30 02:01:32 |
| Message-ID: | A1CC9E8EDC33E74C84357A70D46C35C1D5ED92@barracuda.denville.fulcoinc.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
My company is looking to use PostgreSQL in place of our existing system.
We currently house data for multiple clients. All of their data is
stored in a single database in different schemas for each client. Mosts
clients have multiple login accounts, which we maintain in a
database-specific USER table (contains full name, company, last login,
etc).
Q: is the PostgreSQL pg_user table the appropriate place for these types
of users, or would it be better design to have a generic "client" login
which subsequently references a second USER table?
Let me know if the question is obscure. I'm trying to keep it brief.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Richard Sydney-Smith | 2005-07-30 03:36:16 | Postgres array types |
| Previous Message | Dann Corbit | 2005-07-30 00:19:34 | Re: Unable to Update a Record |