4 ms·
I think you can search for column names by querying the information_schema to the table schema (at least in postgres) select table_name from inf
by screature2 10y ago
I think you can search for column names by querying the information_schema to the table schema (at least in postgres)
select
table_name
from
information_schema.columns
where
column_name ilike '%foo%';
see https://www.postgresql.org/docs/devel/static/infoschema-columns.html https://www.postgresql.org/docs/devel/static/infoschema-colu...
For searching for items with '%foo%' in all tables and columns, yeah i think that you're probably right.
http://stackoverflow.com/questions/5350088/how-to-search-a-specific-value-in-all-tables-postgresql http://stackoverflow.com/questions/5350088/how-to-search-a-s...
- ZenoArrow 10y ago> "For searching for items with '%foo%' in all tables and columns" To do this you could perform two queries of the information_schema (one query for '%foo%' in tables, one query for '%foo%' in columns) and join them together with a UNION statement (or if you didn't mind duplicates you could use UNION ALL in this case as it's faster and the results from both queries can have the same fields).
- JoBrad 10y agoYou can do this in Hive SQL, too. https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Select#LanguageManualSelect-REGEXColumnSpecification https://cwiki.apache.org/confluence/display/Hive/LanguageMan...