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)
Список
Дерево обсуждения
Getting all tables which contains a specific column name "Ridvan Lakas ng Bayan S. Baluyos" <ridvan@baluyos.net>
Re: Getting all tables which contains a specific column name "A. Kretschmer" <andreas.kretschmer@schollglas.com>
Re: Getting all tables which contains a specific column name "Ridvan Lakas ng Bayan S. Baluyos" <ridvan@baluyos.net>
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
Дата:
Следующее
От: Robert Campbell
Дата:
Сообщение: Workaround for bug #4608?
FAQ