From: | Mark Rae <mrae(at)purplebat(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Database Comments |
Date: | 2005-10-07 15:45:05 |
Message-ID: | 20051007154504.GB31788@purplebat.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi,
Using COMMENT ON DATABASE only allows you to create a comment
for your current database which is then only visible from that database.
However, if I manually insert appropriate values into pg_description
in other databases I can make comments appear for another database.
e.g. If some users have access to databases A,B&C, I can insert
values so that the users can see descriptions for each database
from any of them.
Is it safe to do this, or can it have unexpected side effects?
Also is there any intention to have a 'COMMENT ON [ROLE|USER|GROUP]'
facility. It would be quite useful to be able to do something like
COMMENT ON USER jbloggs IS 'Joe Bloggs <j(dot)bloggs(at)foo(dot)bar>'
-Mark
From | Date | Subject | |
---|---|---|---|
Next Message | David Fetter | 2005-10-07 15:47:52 | Re: PostgreSQL 8.1 vs. MySQL 5.0? |
Previous Message | Oleg Bartunov | 2005-10-07 15:38:22 | Re: How to inject knowledge into a Postgres database |