Re: catalog of postgres - Mailing list pgsql-admin

From Alvaro Herrera
Subject Re: catalog of postgres
Date
Msg-id 20050427180931.GC27525@dcc.uchile.cl
Whole thread Raw
In response to catalog of postgres  (Mario Soto Cordones <msotocl@gmail.com>)
Responses Re: catalog of postgres
List pgsql-admin
On Wed, Apr 27, 2005 at 02:02:09PM -0400, Mario Soto Cordones wrote:

> with this query I obtain the schema name and the objects of this it , but
>  like I can know that they are, that is to say if they are tables,
> views, functions, sequences, etc ????????

See pg_class.relkind.

--
Alvaro Herrera (<alvherre[@]dcc.uchile.cl>)
"El día que dejes de cambiar dejarás de vivir"

pgsql-admin by date:

Previous
From: Mario Soto Cordones
Date:
Subject: catalog of postgres
Next
From: Mario Soto Cordones
Date:
Subject: Re: catalog of postgres