Where are database comments stored?

norbert_krupa

When creating a database, there is a field for comments in the admintools UI:

 Vertica Analytic Database 7.1.0-1 Administration Tools  +------------------------------------------------------+-  | Create Database                                      |  | +--------------------------------------------------+ |  | |Database name:                                    | |  | |Comments:                                         | |  | |                                                  | |  | |                                                  | |  | |                                                  | |  | |                                                  | |  | |                                                  | |  | |                                                  | |  | +--------------------------------------------------+ |  +------------------------------------------------------+  |         <  OK  >    < Cancel >    < Help >           |  +------------------------------------------------------+

Where are these comments stored?

Curtis_1

Seems like we had an internal conversation about this not too long. I'm not sure anyone actually found them. 

There is a table called "comments" but it seems it doesn't actually store the database comments. I was under the impression that it did at one time, but someone with an older version verified that it did not. 

So, apparently, database comments are getting filed away into the proverbial bit bucket, it would seem.

eli_revach

I have no test it  ! , did you try  look into the Comments.txt file ?  its located in /opt/vertica/bin/help

Mint_Notini

I did some testing and found that the comment created during database creation does not get saved to any file in help.

norbert_krupa

I then have an enhancement request to make this field functional.

Bhawana

Hi Norbert,

I will try it on my database if needed I will file an enchantment request on this.


Regards

Bhawana

norbert_krupa

Thank you very much!

Bhawana

Hi Norbert,

Enchantment request has been filed.

Regards

Bhawana