How to search tables for a specific column name in PostgreSQL?
Let’s say you have a massive database with many tables and columns. You want to search for a specific column name but don’t know where to start. No worries. Here’s a simple way you can do so: [https://stackoverflow.com/questions/18508422/how-to-find-a-table-having-a-specific-column-in-postgresql] select table_name from information_schema.columns where column_name = ‘your_column_name’ An example with orders table and order_id column name: | table_name | | — — — — — — | | orders | ex