Is there a schema search tool similar to Redgate SQL search available for postgres (preferably free or part of jetbrains suite)? I need the ability to do things such as scan a database(s) for the existence of a column in some unknown table X.
System Info:
postgresql v9.5
DataGrip
Mac
select distinct table_schema, table_name from information_schema.columns where column_name = 'some_column'
– a_horse_with_no_name May 12 '17 at 19:24