Hello All,
I am trying to find the system table which shows me view name.
I know I can see the view name through meta command \dv
But I want to know the system table to access the view name.
I tried view table and view columns table, but could not find view name.
Thanks
view name
Moderator: NorbertKrupa
-
- GURU
- Posts: 527
- Joined: Tue Oct 22, 2013 9:36 pm
- Location: Chicago, IL
- Contact:
Re: view name
I think you're looking for v_catalog.views and v_catalog.view_columns.
Checkout vertica.tips for more Vertica resources.
Re: view name
Hi norbert,
My question was regarding checking the view_name.
I cannot find view_name column in any of the mentioned tables.
My question was regarding checking the view_name.
I cannot find view_name column in any of the mentioned tables.
-
- GURU
- Posts: 527
- Joined: Tue Oct 22, 2013 9:36 pm
- Location: Chicago, IL
- Contact:
Re: view name
There is no such column, unless you're talking about Flex views in 7.
Checkout vertica.tips for more Vertica resources.
Re: view name
The column is unintuitively named table_name. (in the views table)
Sharon Cutter
Vertica Consultant, Zazz Technologies LLC
Vertica Consultant, Zazz Technologies LLC
Re: view name
Thanks Sharon,
I was thinking the same about this column
I was thinking the same about this column