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 <jo...@jfcomputer.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@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-sql > -- --------------------------------------- Viktor Bojović --------------------------------------- Wherever I go, Murphy goes with me