Re: is there a refactor

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
/>