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 === ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
