Re: is there a refactor

From: Viktor Bojović <viktor(dot)bojovic(at)gmail(dot)com>
To: John Fabiani <johnf(at)jfcomputer(dot)com>
Cc: PostgreSQL - SQL <pgsql-sql(at)postgresql(dot)org>
Subject: Re: is there a refactor
Date: 2011-04-05 14:39:10
Message-ID: BANLkTinwaGUox8+zDm9kZWHmtJdMAqMMKw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi John,

everything you need is stored in these tables:
http://www.postgresql.org/docs/7.4/static/catalog-pg-attribute.html
http://www.postgresql.org/docs/7.4/static/catalog-pg-class.html
http://www.postgresql.org/docs/7.4/static/catalog-pg-namespace.html

On Tue, Apr 5, 2011 at 4:27 PM, John Fabiani <johnf(at)jfcomputer(dot)com> 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
>
> --
> Sent via pgsql-sql mailing list (pgsql-sql(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-sql
>

--
---------------------------------------
Viktor Bojović
---------------------------------------
Wherever I go, Murphy goes with me

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Adrian Klaver 2011-04-05 14:44:51 Re: is there a refactor
Previous Message John Fabiani 2011-04-05 14:27:24 is there a refactor