How to search column_names in Vertica?

search vertica
timssopomo picture timssopomo · Apr 6, 2012 · Viewed 11.3k times · Source

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!

Answer

Camilo picture Camilo · Apr 12, 2012

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

Related questions

grep a file, but show several surrounding lines?

I would like to grep for a string, but also show the preceding five lines and the following five lines as well as the matched line. How would I be able to do this?

Read More
How can I exclude one word with grep?

I need something like: grep ^"unwanted_word"XXXXXXXX

Read More
grep, but only certain file extensions

I am working on writing some scripts to grep certain directories, but these directories contain all sorts of file types. I want to grep just .h and .cpp for now, but maybe a few others in the future. So far …

Read More