You could also do something like:<br /><br />select nspname, relname, attname <br />from pg_attribute a<br /> JOIN
pg_classc ON (a.attrelid = c.oid)<br /> JOIN pg_namespace n ON (n.oid = c.relnamespace)<br />where a.attname ~
'yourcolumn'<br/> and c.relname !~ 'pg'<br />and n.nspname not in ('pg_catalog','information_schema')<br />order by
1,2,3;<br/><br />I'd functionalize it.<br /><br /><div class="gmail_quote">On Tue, Apr 5, 2011 at 10:44 AM, Adrian
Klaver<span dir="ltr"><<a href="mailto:adrian.klaver@gmail.com">adrian.klaver@gmail.com</a>></span> wrote:<br
/><blockquoteclass="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204);
padding-left:1ex;">On Tuesday, April 05, 2011 7:27:24 am John Fabiani wrote:<br /> > Hi,<br /> > I would like to
havea simple way to retrieve information for a field name.<br /> > By that I mean have some SQL select that will
returnall the tables a field<br /> > name exist within a database. I did not find anything with google but of<br />
>course google depends on the search string.<br /> ><br /> > Thanks in advance,<br /> > Johnf<br /><br />
test(5432)aklaver=>SELECTtable_name from information_schema.columns where<br /> column_name = 'id';<br />
table_name<br/> ----------------<br /> user_test<br /> table2<br /> table1<br /> hours<br /> jedit_test<br />
topics<br/> t2<br /> stone<br /> serial_test<br /> messages<br /> binary_test<br /> user_test<br />
timestamp_test<br/> role_t<br /> py_test<br /> money_test<br /> lock_test<br /> local_1<br /> lang_test<br />
interval_test<br/> foob<br /> fooa<br /> fldlength<br /> fk_1<br /> default_test<br /> csv_null<br />
check_two<br/> check_test<br /> array_test<br /> (29 rows)<br /><br /> --<br /> Adrian Klaver<br /><a
href="mailto:adrian.klaver@gmail.com">adrian.klaver@gmail.com</a><br/><font color="#888888"><br /> --<br /> Sent via
pgsql-sqlmailing list (<a href="mailto:pgsql-sql@postgresql.org">pgsql-sql@postgresql.org</a>)<br /> To make changes to
yoursubscription:<br /><a href="http://www.postgresql.org/mailpref/pgsql-sql"
target="_blank">http://www.postgresql.org/mailpref/pgsql-sql</a><br/></font></blockquote></div><br /><br clear="all"
/><br/>-- <br />Peter Steinheuser<br /><a href="mailto:psteinheuser@myyearbook.com">psteinheuser@myyearbook.com</a><br
/>
