From: Peter Steinheuser <psteinheuser@myyearbook.com>
To: Adrian Klaver <adrian.klaver@gmail.com>
Cc: pgsql-sql@postgresql.org, John Fabiani <johnf@jfcomputer.com>
Subject: Re: is there a refactor
Date: Tue, 5 Apr 2011 10:49:54 -0400
Message-ID: <BANLkTimqv-k0n7Fvq8Tg+6H3MWDrf3zBAw@mail.gmail.com> (raw)
In-Reply-To: <201104050744.52471.adrian.klaver@gmail.com>
References: <201104050727.24713.johnf@jfcomputer.com>
<201104050744.52471.adrian.klaver@gmail.com>
You could also do something like:
select nspname, relname, attname
from pg_attribute a
JOIN pg_class c ON (a.attrelid = c.oid)
JOIN pg_namespace n ON (n.oid = c.relnamespace)
where a.attname ~ 'yourcolumn'
and c.relname !~ 'pg'
and n.nspname not in ('pg_catalog','information_schema')
order by 1,2,3;
I'd functionalize it.
On Tue, Apr 5, 2011 at 10:44 AM, Adrian Klaver <adrian.klaver@gmail.com>wrote:
> On Tuesday, April 05, 2011 7:27:24 am John Fabiani wrote:
> > Hi,
> > I would like to have a simple way to retrieve information for a field
> name.
> > By that I mean have some SQL select that will return all the tables a
> field
> > name exist within a database. I did not find anything with google but of
> > course google depends on the search string.
> >
> > Thanks in advance,
> > Johnf
>
> test(5432)aklaver=>SELECT table_name from information_schema.columns where
> column_name = 'id';
> table_name
> ----------------
> user_test
> table2
> table1
> hours
> jedit_test
> topics
> t2
> stone
> serial_test
> messages
> binary_test
> user_test
> timestamp_test
> role_t
> py_test
> money_test
> lock_test
> local_1
> lang_test
> interval_test
> foob
> fooa
> fldlength
> fk_1
> default_test
> csv_null
> check_two
> check_test
> array_test
> (29 rows)
>
> --
> Adrian Klaver
> adrian.klaver@gmail.com
>
> --
> Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-sql
>
--
Peter Steinheuser
psteinheuser@myyearbook.com
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: psteinheuser@myyearbook.com, adrian.klaver@gmail.com, johnf@jfcomputer.com
Subject: Re: is there a refactor
In-Reply-To: <BANLkTimqv-k0n7Fvq8Tg+6H3MWDrf3zBAw@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox