Search Postgresql Archives

Database Comments

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.bloggs@xxxxxxx>'

    -Mark

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux