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.