Adam Haberlach <adam(at)newsnipple(dot)com> writes:
> got a QA guy here who says "every other database I've worked with
> lets people add their own fields to the user tables, why can't you
> just do that".
Oh? News to me. How does he expect the system to fill the extra
fields?
> Is it safe to modify pg_shadow?
Strikes me as pretty risky, but you *might* get away with adding
more fields at the end with NULL defaults. Don't try to add indexes,
constraints, rules or triggers, as they won't work.
regards, tom lane