Skip site navigation (1) Skip section navigation (2)

Re: Getting all tables which contains a specific column name

From: "Ridvan Lakas ng Bayan S(dot) Baluyos" <ridvan(at)baluyos(dot)net>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: Getting all tables which contains a specific column name
Date: 2009-04-22 06:48:05
Message-ID: 7f4f9efa0904212348y235ed891sfe7234747f7e1609@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
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(at)baluyos(dot)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(dot)baluyos(at)qualservcentral(dot)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(dot)baluyos(at)qualservcentral(dot)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.

In response to

pgsql-novice by date

Next:From: A. KretschmerDate: 2009-04-22 06:59:59
Subject: Re: Getting all tables which contains a specific column name
Previous:From: Ridvan Lakas ng Bayan S. BaluyosDate: 2009-04-22 06:45:08
Subject: Getting all tables which contains a specific column name

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group