Re: Getting all tables which contains a specific column name

Поиск
Список
Период
Сортировка
От Ridvan Lakas ng Bayan S. Baluyos
Тема Re: Getting all tables which contains a specific column name
Дата
Msg-id 7f4f9efa0904212348y235ed891sfe7234747f7e1609@mail.gmail.com
обсуждение исходный текст
Ответ на Getting all tables which contains a specific column name  ("Ridvan Lakas ng Bayan S. Baluyos" <ridvan@baluyos.net>)
Список 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@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 по дате отправления:

Предыдущее
От: "A. Kretschmer"
Дата:
Сообщение: Re: Getting all tables which contains a specific column name
Следующее
От: Robert Campbell
Дата:
Сообщение: Workaround for bug #4608?