Re: catalog of postgres - Mailing list pgsql-admin

From Mario Soto Cordones
Subject Re: catalog of postgres
Date
Msg-id e9b17cde050427111471ef2bb3@mail.gmail.com
Whole thread Raw
In response to Re: catalog of postgres  (Alvaro Herrera <alvherre@dcc.uchile.cl>)
Responses Re: catalog of postgres  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: catalog of postgres  (Lyubomir Petrov <lpetrov@sysmaster.com>)
List pgsql-admin
OK but views and tables for example have the same one relkind

thank



2005/4/27, Alvaro Herrera <alvherre@dcc.uchile.cl>:
> 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"
>


--
cordialmente,

Ing. Mario Soto Cordones

pgsql-admin by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: catalog of postgres
Next
From: Tom Lane
Date:
Subject: Re: catalog of postgres