List of vs_ tables...

[harryrundles]

Anyone have a list of all the vs_* tables in Vertica?

[jpcavanaugh]

Which version of the database? Those tables change release-2-release.

[id10t]

Hi!

Try

Code: Select all

select * from vs_system_tables;

Code: Select all

select * from vs_system_tables where table_name like 'vs_%';

[harryrundles]

Thank you, guys!

I am running 6.0.0-0. I'm thinking of upgrading to the latest 6.0.1-0 soon, though.