Hey,
When creating a DB in admintools we have the option to add a "comment" when naming the DB. Anyone know where (i.e. system table) in the DB the comment can be retrieved?
Thanks in advance!
Where can I find DB comment???
Moderator: NorbertKrupa
Where can I find DB comment???
Thank you!
Joshua
Joshua
-
NorbertKrupa
- GURU
- Posts: 527
- Joined: Tue Oct 22, 2013 9:36 pm
- Location: Chicago, IL
- Contact:
Re: Where can I find DB comment???
I played around with that one for a while. It's a (what's the word for a non-functional field)?
Checkout vertica.tips for more Vertica resources.
Re: Where can I find DB comment???
Hi!
[DELETED]
[DELETED]
Last edited by id10t on Mon May 04, 2015 9:17 pm, edited 1 time in total.
-
JimKnicely
- Site Admin
- Posts: 1825
- Joined: Sat Jan 21, 2012 4:58 am
- Contact:
Re: Where can I find DB comment???
It's interesting to note that there is no COMMENT ON DATABASE SQL command 
From the SQL Guide:
COMMENT ON Statements
The following functions allow you to create comments associated with HP Vertica database objects:
From the SQL Guide:
COMMENT ON Statements
The following functions allow you to create comments associated with HP Vertica database objects:
- COMMENT ON COLUMN
COMMENT ON CONSTRAINT
COMMENT ON FUNCTION
COMMENT ON LIBRARY
COMMENT ON NODE
COMMENT ON PROJECTION
COMMENT ON SCHEMA
COMMENT ON SEQUENCE
COMMENT ON TABLE
COMMENT ON TRANSFORM FUNCTION
COMMENT ON VIEW
Jim Knicely
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.
Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.