Re: [GENERAL] Object-oriented stuff and postgres

1999-04-21 Thread Chris Bitmead
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_

Re: [GENERAL] Object-oriented stuff and postgres

1999-04-21 Thread José Soares
--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