2

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

1
  • select distinct table_schema, table_name from information_schema.columns where column_name = 'some_column'
    – user14090
    May 12, 2017 at 19:24

0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Browse other questions tagged or ask your own question.