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
--
リヅバン バルヨス
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.
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 по дате отправления: