As I'm managing accounts for students... I noticed that there does not
seem to be a proper way to keep a comment about a postgresql user account,
such as the full name of the student or its email, that I could see with
\du or some system query. My solution is to keep the "mapping" somewhere
else, but having that in the database directly, just like the gecos field
in a unix password file, would help managing the stuff.
Thus I would suggest to add one new text field in pg_group and pg_shadow
for this purpose, that could be initialized with something like:
CREATE USER calvin COMMENT 'Calvin <calvin(at)comics(dot)org>';
Alternatively, it could be managed with "COMMENT ON ..."? Well, users or
groups are not really database objects... so it does not really fit.
If there is some kind of agreement about this, maybe it could be added to
the todo list for 8.1 (or later;-)?
Have a nice day,
pgsql-hackers by date
|Next:||From: Laszlo Hornyak||Date: 2004-09-22 13:02:22|
|Subject: Re: elog in 7.4 |
|Previous:||From: Iulia Pacurar||Date: 2004-09-22 07:29:51|