Postgres Pro
Downloads
Home   >   mailing lists

Re: Get all table names that have a specific column - Mailing list pgsql-general

From A. Kretschmer
Subject Re: Get all table names that have a specific column
Date
Msg-id 20050930153004.GB16263@webserv.wug-glas.de
Whole thread Raw
In response to Get all table names that have a specific column  (Emi Lu <emilu@cs.concordia.ca>)
List pgsql-general
Tree view 
am  30.09.2005, um 10:55:44 -0400 mailte Emi Lu folgendes:
> Greetings,
>
> I am not very familiar with the system views/tables in postgreSQL. I'd like
> to get all table names that have a column let's say named "col1".

select table_name from information_schema.columns where column_name = 'col1';


Regards, Andreas
--
Andreas Kretschmer    (Kontakt: siehe Header)
Heynitz:  035242/47212,      D1: 0160/7141639
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
 ===    Schollglas Unternehmensgruppe    ===

pgsql-general by date:

Previous
From: Emi Lu
Date:
Subject: Get all table names that have a specific column
Next
From: "William ZHANG"
Date:
Subject: Re: Get all table names that have a specific column