Re: catalog of postgres

From: Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>
To: Mario Soto Cordones <msotocl(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: catalog of postgres
Date: 2005-04-27 18:09:31
Message-ID: 20050427180931.GC27525@dcc.uchile.cl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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[(at)]dcc(dot)uchile(dot)cl>)
"El día que dejes de cambiar dejarás de vivir"

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Mario Soto Cordones 2005-04-27 18:14:59 Re: catalog of postgres
Previous Message Mario Soto Cordones 2005-04-27 18:02:09 catalog of postgres