I wrote:
> Jim Mercer <jim(at)reptiles(dot)org> writes:
>> where are these relations? is this a compile-time thing, or can it be done
>> on-the-fly?
> Compile-time; see SharedSystemRelationNames in
> backend/utils/init/globals.c. You'd have to do an initdb after changing
> it, anyway.
BTW, the reason that pg_shadow is installation-wide is that it's
not real clear what the 'ownership' column in pg_database means
if users are not installation-wide. Before cutting and hacking,
you'd need to think carefully about just what semantics you are
really after.
regards, tom lane