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 6F39453666 for ; Wed, 27 Apr 2005 15:02:18 -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 76793-08 for ; Wed, 27 Apr 2005 18:02:11 +0000 (GMT) Received: from zproxy.gmail.com (zproxy.gmail.com [64.233.162.204]) by svr1.postgresql.org (Postfix) with ESMTP id E3B2453613 for ; Wed, 27 Apr 2005 15:02:09 -0300 (ADT) Received: by zproxy.gmail.com with SMTP id 34so526529nzf for ; Wed, 27 Apr 2005 11:02:09 -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:mime-version:content-type:content-transfer-encoding:content-disposition; b=m2NiEwCib+SM4skv7aJd/B5tyXGB/L/hSzkqqyplSPIWxZp8O4kP/rO9lI7hVn58KmAs/0393nnD1/1Y4uFzKoNlNvkewIJUsU/qQuZjECAUayuLvcybKkaqvdlzJFTah2oK+TMdD106s02/MnIO326RVtjg/KtxG2I0L5bnFPo= Received: by 10.36.61.11 with SMTP id j11mr56089nza; Wed, 27 Apr 2005 11:02:09 -0700 (PDT) Received: by 10.36.57.11 with HTTP; Wed, 27 Apr 2005 11:02:09 -0700 (PDT) Message-ID: Date: Wed, 27 Apr 2005 14:02:09 -0400 From: Mario Soto Cordones Reply-To: Mario Soto Cordones To: pgsql-admin@postgresql.org Subject: catalog of postgres Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.64 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, RCVD_BY_IP X-Spam-Level: X-Archive-Number: 200504/384 X-Sequence-Number: 17397 Hi guys =20 i have a following query: SELECT nspname as schema, relname as objeto 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 order by nspname, relname asc 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 ???????? thank for all --=20 cordialmente, Ing. Mario Soto Cordones