Skip site navigation (1) Skip section navigation (2)

Re: catalog of postgres

From: Mario Soto Cordones <msotocl(at)gmail(dot)com>
To: Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: catalog of postgres
Date: 2005-04-27 18:14:59
Message-ID: e9b17cde050427111471ef2bb3@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
OK but views and tables for example have the same one relkind 

thank



2005/4/27, Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)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[(at)]dcc(dot)uchile(dot)cl>)
> "El día que dejes de cambiar dejarás de vivir"
> 


-- 
cordialmente,

Ing. Mario Soto Cordones

In response to

Responses

pgsql-admin by date

Next:From: Tom LaneDate: 2005-04-27 18:29:47
Subject: Re: catalog of postgres
Previous:From: Alvaro HerreraDate: 2005-04-27 18:09:31
Subject: Re: catalog of postgres

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group