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

  • 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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.