Received: from maia.hub.org (maia-2.hub.org [200.46.204.251])
	by mail.postgresql.org (Postfix) with ESMTP id EAB6E1337BF5
	for <pgsql-sql-postgresql.org@mail.postgresql.org>;
	Tue,  5 Apr 2011 11:39:30 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia,
	port 10024) with ESMTP id 97547-03 for
	<pgsql-sql-postgresql.org@mail.postgresql.org>;
	Tue,  5 Apr 2011 14:39:12 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from mail-vw0-f46.google.com (mail-vw0-f46.google.com
	[209.85.212.46])
	by mail.postgresql.org (Postfix) with ESMTP id 16F4B1337BF2
	for <pgsql-sql@postgresql.org>; Tue,  5 Apr 2011 11:39:11 -0300 (ADT)
Received: by vws1 with SMTP id 1so299175vws.19
	for <pgsql-sql@postgresql.org>; Tue, 05 Apr 2011 07:39:12 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:mime-version:in-reply-to:references:date
	:message-id:subject:from:to:cc:content-type;
	bh=KWcb9rmoZaSn2xHaTj10rK5ETPp1nz5Nn5nAiO/3DmQ=;
	b=xBUQtBurr97zhIkO1X1h9BdpiVMTokOTsjOKdBOLQOZJAsTkeOKsAhWWuFlLfyJS+Z
	GLC7pCimQLJtiwV46tv6yY5vQWU2pDHql0NNFIqjPPlBTDpTbaCJmj/PN2N3xTxAS+Tx
	BKOmhSxWcMX/VgOHWm60OW5ERrvN3wc6pbYoI=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:in-reply-to:references:date:message-id:subject:from:to
	:cc:content-type;
	b=s82Cn+XORkNEB8tRbXNhDwEIJxT3+il4oPrbuDn1Xh9Gp7QzRL3lyLMP1sddWexfTB
	sUpsTiRbGBTyW6I+mH46d3aiy/5Cz7dZbWNuVQAIUSCnym50i7mWzIgKGsGD0CCFC7G0
	rXhsDVUsZ/IjNqw+IKrC0e1oaUBKdNgPWrrdo=
MIME-Version: 1.0
Received: by 10.52.92.172 with SMTP id cn12mr1795580vdb.294.1302014350514;
	Tue, 05 Apr 2011 07:39:10 -0700 (PDT)
Received: by 10.220.181.8 with HTTP; Tue, 5 Apr 2011 07:39:10 -0700 (PDT)
In-Reply-To: <201104050727.24713.johnf@jfcomputer.com>
References: <201104050727.24713.johnf@jfcomputer.com>
Date: Tue, 5 Apr 2011 16:39:10 +0200
Message-ID: <BANLkTinwaGUox8+zDm9kZWHmtJdMAqMMKw@mail.gmail.com>
Subject: Re: is there a refactor
From: =?UTF-8?Q?Viktor_Bojovi=C4=87?= <viktor.bojovic@gmail.com>
To: John Fabiani <johnf@jfcomputer.com>
Cc: PostgreSQL - SQL <pgsql-sql@postgresql.org>
Content-Type: multipart/alternative; boundary=20cf3071c770dadb5d04a02cd6d4
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.898 tagged_above=-5 required=5 tests=BAYES_00=-1.9,
	FREEMAIL_FROM=0.001, HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 201104/2
X-Sequence-Number: 35249

--20cf3071c770dadb5d04a02cd6d4
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

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@jfcomputer.com> wrote:

> Hi,
> I would like to have a simple way to retrieve information for a field nam=
e.
> By that I mean have some SQL select that will return all the tables a fie=
ld
> 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@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-sql
>



--=20
---------------------------------------
Viktor Bojovi=C4=87
---------------------------------------
Wherever I go, Murphy goes with me

--20cf3071c770dadb5d04a02cd6d4
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

Hi John,<br><br>everything you need is stored in these tables:<br><a href=
=3D"http://www.postgresql.org/docs/7.4/static/catalog-pg-attribute.html">ht=
tp://www.postgresql.org/docs/7.4/static/catalog-pg-attribute.html</a><br><a=
 href=3D"http://www.postgresql.org/docs/7.4/static/catalog-pg-class.html">h=
ttp://www.postgresql.org/docs/7.4/static/catalog-pg-class.html</a><br>
<a href=3D"http://www.postgresql.org/docs/7.4/static/catalog-pg-namespace.h=
tml">http://www.postgresql.org/docs/7.4/static/catalog-pg-namespace.html</a=
><br><br><br><div class=3D"gmail_quote">On Tue, Apr 5, 2011 at 4:27 PM, Joh=
n Fabiani <span dir=3D"ltr">&lt;<a href=3D"mailto:johnf@jfcomputer.com">joh=
nf@jfcomputer.com</a>&gt;</span> wrote:<br>
<blockquote class=3D"gmail_quote" style=3D"margin: 0pt 0pt 0pt 0.8ex; borde=
r-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">Hi,<br>
I would like to have a simple way to retrieve information for a field name.=
<br>
By that I mean have some SQL select that will return all the tables a field=
<br>
name exist within a database. =C2=A0I did not find anything with google but=
 of<br>
course google depends on the search string.<br>
<br>
Thanks in advance,<br>
Johnf<br>
<font color=3D"#888888"><br>
--<br>
Sent via pgsql-sql mailing list (<a href=3D"mailto:pgsql-sql@postgresql.org=
">pgsql-sql@postgresql.org</a>)<br>
To make changes to your subscription:<br>
<a href=3D"http://www.postgresql.org/mailpref/pgsql-sql" target=3D"_blank">=
http://www.postgresql.org/mailpref/pgsql-sql</a><br>
</font></blockquote></div><br><br clear=3D"all"><br>-- <br>----------------=
-----------------------<br>Viktor Bojovi=C4=87<br>-------------------------=
--------------<br>Wherever I go, Murphy goes with me<br>

--20cf3071c770dadb5d04a02cd6d4--