Re: catalog of postgres

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[(at)]dcc(dot)uchile(dot)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.