sql - How to find a table having a specific column in postgresql

Question

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

I'm using PostgreSQL 9.1. I have the column name of a table. Is it possible to find the table(s) that has/have this column? If so, how?

See Question&Answers more detail:os

与恶龙缠斗过久,自身亦成为恶龙；凝视深渊过久,深渊将回以凝视…

330 views

1 Answer

深蓝 · Answer 1 · 2021-10-17T00:56:13+0000

answered Oct 17, 2021 by 深蓝 (71.8m points)

You can also do

 select table_name from information_schema.columns where column_name = 'your_column_name'

与恶龙缠斗过久,自身亦成为恶龙；凝视深渊过久,深渊将回以凝视…