Search code examples
searchvertica

How to search column_names in Vertica?

Anyone know of a handy function to search through column_names in Vertica? From the documentation, it seems like \d only queries table_names. I'm looking for something like MySQL's information_schema.columns, but can't find any information about a similar table of meta-data.

Thanks!

Solution

  • In 5.1 if you have enough permissions you can do 

    SELECT * FROM v_catalog.columns;

    to access columns's info, for some things you'll need to join with 

    v_catalog.tables