On Wed, Apr 27, 2005 at 03:57:41PM -0400, Mario Soto Cordones wrote: > SELECT nspname as esquema, relname as objeto, > (CASE relkind > WHEN 'v' THEN 'Vista' > WHEN 'i' THEN 'Indice' > WHEN 'S' THEN 'Secuencia' > WHEN 'r' THEN 'Tabla' > WHEN 'c' THEN 'Tipo' > END) as tipo > FROM > pg_class bc, > pg_attribute ta, > pg_namespace ns, > pg_type ty > WHERE > ta.attrelid = bc.oid > and ta.attnum > 0 > and not ta.attisdropped > and nspname <> 'information_schema' and nspname not like 'pg_%' > ----and relam = 0 > and bc.relnamespace = ns.oid > and bc.relname not like 'pg_%' > and ta.atttypid = ty.oid > group by nspname, relname, relkind > order by tipo desc Why are you using a group by here? It's unnecesary. > but not you where they stay the functions See the pg_proc catalog. I wonder if I have pointed you to the documentation before? See the "system catalogs" section in the internals chapter. Also, maybe you should take a look at whether the information_schema gives you what you want. -- Alvaro Herrera (<alvherre[@]dcc.uchile.cl>) Y una voz del caos me habló y me dijo "Sonríe y sé feliz, podría ser peor". Y sonreí. Y fui feliz. Y fue peor.
