Postgres Pro
Downloads
Home   >   mailing lists

Re: Getting all tables which contains a specific column name - Mailing list pgsql-novice

From Ridvan Lakas ng Bayan S. Baluyos
Subject Re: Getting all tables which contains a specific column name
Date
Msg-id 7f4f9efa0904212348y235ed891sfe7234747f7e1609@mail.gmail.com
Whole thread Raw
In response to Getting all tables which contains a specific column name  ("Ridvan Lakas ng Bayan S. Baluyos" <ridvan@baluyos.net>)
List pgsql-novice
Tree view
Ok I got it already.

SELECT table_name
FROM information_schema.columns
WHERE column_name = 'is_active'
ORDER BY ordinal_position;

I don't know if this is correct. Please correct me if I'm wrong.


Thanks,

Ridvan
On Wed, Apr 22, 2009 at 2:45 PM, Ridvan Lakas ng Bayan S. Baluyos <ridvan@baluyos.net> wrote:
Hi list,

How do I get all the tables which contains a specific column name? For example, I want to get all tables that has an `is_active` column in them?


Thanks,

Ridvan

--
リヅバン バルヨス
ridvan.baluyos@qualservcentral.com
http://ridvan.baluyos.net
http://www.onxiam.com/people/rbaluyos

Registered Linux User #439466
Registered Ubuntu User #16034
Q: Have you heard of the Object-Oriented way to get wealthy?
A: Inheritance.



--
リヅバン バルヨス
ridvan.baluyos@qualservcentral.com
http://ridvan.baluyos.net
http://www.onxiam.com/people/rbaluyos

Registered Linux User #439466
Registered Ubuntu User #16034
Q: Have you heard of the Object-Oriented way to get wealthy?
A: Inheritance.

pgsql-novice by date:

Previous
From: "A. Kretschmer"
Date:
Subject: Re: Getting all tables which contains a specific column name
Next
From: Robert Campbell
Date:
Subject: Workaround for bug #4608?