System Table that Shows a View's Data Type?

Moderator: NorbertKrupa

Post Reply
User avatar
Julie
Master
Master
Posts: 221
Joined: Thu Apr 19, 2012 9:29 pm

System Table that Shows a View's Data Type?

Post by Julie » Wed Jul 16, 2014 8:17 pm

Hello,

Is there a system table like V_CATALOG.COLUMNS but shows data type for view columns not tables?

Thank you
Thanks,
Juliette
Top
NorbertKrupa
GURU
GURU
Posts: 527
Joined: Tue Oct 22, 2013 9:36 pm
Location: Chicago, IL
Contact:
Contact NorbertKrupa

Re: System Table that Shows a View's Data Type?

Post by NorbertKrupa » Wed Jul 16, 2014 8:25 pm

I think you're looking for v_catalog.view_columns.
Checkout vertica.tips for more Vertica resources.
Top
Post Reply

Return to “Vertica Database Administration”