![Finding all tables with a specific column name (postgres) cover image](https://www.ananunesdasilva.com/rails/active_storage/representations/redirect/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaHBBWTA9IiwiZXhwIjpudWxsLCJwdXIiOiJibG9iX2lkIn19--3cade6d85bfb9a9f18bec714bc0df1c8eba2174a/eyJfcmFpbHMiOnsibWVzc2FnZSI6IkJBaDdCem9MWm05eWJXRjBTU0lJY0c1bkJqb0dSVlE2RkhKbGMybDZaVjkwYjE5c2FXMXBkRnNIYVFJc0FXa0NMQUU9IiwiZXhwIjpudWxsLCJwdXIiOiJ2YXJpYXRpb24ifX0=--1720debe1f7917c7ab26aa8cb126ec525096cd9c/postgres%20search%20tables%20with%20column%20(1).png)
Finding all tables with a specific column name (postgres)
Jan, 2022
Postgres has a really handy schema from which you can retrieve information about your database. Here's how you can use it to get all tables with a specific column name, and when this might be useful.