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_
--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
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 (webob
