How to find a table having a specific column in postgresql

sql database postgresql postgresql-9.1
Hasan Iqbal picture Hasan Iqbal · Aug 29, 2013 · Viewed 61.5k times · Source

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?

Answer

Ravi Shekhar picture Ravi Shekhar · Jul 30, 2015

You can also do

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

Related questions

Strange PostgreSQL "value too long for type character varying(500)"

I have a Postgres schema which looks like: The problem is that whenever I save text longer than 500 characters in the description column I get the error: value too long for type character varying(500) In the documentation for Postgres it …

Read More
What's a PostgreSQL "Cluster" and how do I create one?

I am very new to databases, I haven't worked lot on it. Now I want to understand the term database clusters. I googled a lot and found many useful links but I am not able to understand them - maybe …

Read More
PostgreSQL - dump each table into a different file

I need to extract SQL files from multiple tables of a PostgreSQL database. This is what I've come up with so far: pg_dump -t 'thr_*' -s dbName -U userName > /home/anik/psqlTest/db_dump.sql However, as …

Read More