How to Find PostgreSQL Tables Containing a Specific Column?

Identifying Tables with a Specific Column in PostgreSQL

In PostgreSQL, you may need to locate tables that contain a particular column. This can be accomplished through the use of SQL queries.

Method 1:

Utilizing the pg_class and pg_attribute system tables, you can retrieve the desired information:

SELECT DISTINCT table_name
FROM pg_class c
JOIN pg_attribute a ON c.oid = a.attrelid
WHERE LOWER(a.attname) = LOWER('your_column_name');

Method 2:

Alternatively, you can leverage the information_schema.columns view:

SELECT table_name
FROM information_schema.columns
WHERE LOWER(column_name) = LOWER('your_column_name');

The above is the detailed content of How to Find PostgreSQL Tables Containing a Specific Column?. For more information, please follow other related articles on the PHP Chinese website!