Umm. I need to know the type of the _object_, not the types of the
attributes contained therein.
José Soares wrote:
>
> --retrieve column information...
>
> SELECT a.attnum, a.attname, t.typname, a.attlen,
> a.atttypmod, a.attnotnull, a.atthasdef
> FROM pg_class c, pg_attribute a, pg_type t
> WHERE c.relname = 'comuni'
> and a.attnum > 0
> and a.attrelid = c.oid
> and a.atttypid = t.oid
> ORDER BY attnum ;
> attnum|attname |typname|attlen|atttypmod|attnotnull|atthasdef
> ------+--------------+-------+------+---------+----------+---------
> 1|istat |bpchar | -1| 10|t |f
> 2|nome |bpchar | -1| 54|t |f
> 3|provincia |bpchar | -1| 6|f |f
> 4|codice_fiscale|bpchar | -1| 8|f |f
> 5|cap |bpchar | -1| 9|f |f
> 6|regione |bpchar | -1| 7|f |f
> 7|distretto |bpchar | -1| 8|f |f
> (7 rows)
>
>
> José
>
> Chris Bitmead ha scritto:
>
> > What's the best way to do this in postgres? (basicly finding the
> > type of
> > objects).
> >
> > I want to run a web site with different types of content - question
> > and
> > answers, stories etc. I propose an object hierarchy...
> > webobject (title, body)
> > question inherits webobject
> > story (image) inherits (webobject).
> >
> > The idea being you could have a search screen that searches
> > questions
> > AND stories with the one SELECT query.
> >
> > But then each result would have a link to examine the body of the
> > search
> > result. But different types of objects would have different URLs to
> > display that content.
> >
> > So basicly I need to know the type of objects returned.
> >
> > I am loath to store the object type inside the object because it is
> > wasteful. PG obviously already knows the type of objects, the
> > question
> > is how to get at that info.
--
Chris Bitmead
http://www.bigfoot.com/~chris.bitmead
mailto:chris.bitmead@bigfoot.com
