On Fri, Apr 21, 2006 at 09:29:33 -0700, Jeff Frost <[EMAIL PROTECTED]> wrote: > Is there a reasonable way to extract a list of all tables which contain a > specific column name from the system views on 8.1? > > For instance, I might want to enumerate all tables with a column named > last_modified.
Take a look at: http://developer.postgresql.org/docs/postgres/infoschema-columns.html and http://developer.postgresql.org/docs/postgres/infoschema-schema.html ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
