X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 6D4F8536CC for ; Wed, 27 Apr 2005 16:57:50 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 45459-08 for ; Wed, 27 Apr 2005 19:57:41 +0000 (GMT) Received: from zproxy.gmail.com (zproxy.gmail.com [64.233.162.205]) by svr1.postgresql.org (Postfix) with ESMTP id 485825367C for ; Wed, 27 Apr 2005 16:57:40 -0300 (ADT) Received: by zproxy.gmail.com with SMTP id 34so579323nzf for ; Wed, 27 Apr 2005 12:57:41 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=t5Y/eHy2RbETBNkFJ5Syd8YIvj1EN/NHrs/8EsmpDxTlRTWx2tQzxJG7vjzjEztYQDzWVXfBKbV9WXOjBl1BkVT8n8AkIyHWMjwGO0KhhrnhNtHI4ApduLH1pnhcnXqLYbGe0QStC397XBgbeYycnkGkOlyHmevgAzU8PNy/BjY= Received: by 10.36.9.2 with SMTP id 2mr62169nzi; Wed, 27 Apr 2005 12:57:41 -0700 (PDT) Received: by 10.36.57.11 with HTTP; Wed, 27 Apr 2005 12:57:41 -0700 (PDT) Message-ID: Date: Wed, 27 Apr 2005 15:57:41 -0400 From: Mario Soto Cordones Reply-To: Mario Soto Cordones To: Tom Lane Subject: Re: catalog of postgres Cc: Alvaro Herrera , pgsql-admin@postgresql.org In-Reply-To: <24929.1114626587@sss.pgh.pa.us> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: <20050427180931.GC27525@dcc.uchile.cl> <24929.1114626587@sss.pgh.pa.us> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.603 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, RCVD_BY_IP X-Spam-Level: X-Archive-Number: 200504/392 X-Sequence-Number: 17405 OK i have a big mistake, i saw bad, now my new query is 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 =3D bc.oid and ta.attnum > 0 and not ta.attisdropped and nspname <> 'information_schema' and nspname not like 'pg_%' ----and relam =3D 0 and bc.relnamespace =3D ns.oid and bc.relname not like 'pg_%' and ta.atttypid =3D ty.oid group by nspname, relname, relkind order by tipo desc =20 select * from pg_class where relkind =3D 'i' but not you where they stay the functions thank you for all 2005/4/27, Tom Lane : > Mario Soto Cordones writes: > > OK but views and tables for example have the same one relkind >=20 > Not for many years now (certainly not in any release that has pg_namespac= e). >=20 > regards, tom lane >=20 --=20 cordialmente, Ing. Mario Soto Cordones