Is there a way to locate a column in the database?
Moderator: NorbertKrupa
Is there a way to locate a column in the database?
Anyone know of a easy way to search the database to find a table with a particular column name? The \d command only queries table names. I'm used to querying a table in MySQL called information_schema.columns. Is there a simlar structure in Vertica?
Re: Is there a way to locate a column in the database?
Code: Select all
select * from columns;
Code: Select all
select table_name from columns where column_name ilike '%particular table name%';
Re: Is there a way to locate a column in the database?
Can anyone issue that select? Or only an admin?
Thank you!
Joshua
Joshua
Re: Is there a way to locate a column in the database?
dbadmin, Pseudosuperuser, owner of tables