X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 8A27AD1EAB9 for ; Mon, 29 Mar 2004 21:51:38 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 05542-06 for ; Mon, 29 Mar 2004 17:51:37 -0400 (AST) Received: from localhost (limacorp.com [66.216.127.144]) by svr1.postgresql.org (Postfix) with SMTP id D1B68D1EA21 for ; Mon, 29 Mar 2004 17:51:34 -0400 (AST) Received: (qmail 15766 invoked by uid 506); 29 Mar 2004 21:51:36 -0000 Received: from thampton@limacorp.com by garbanzo.limacorp.com by uid 506 with qmail-scanner-1.16 (spamassassin: 2.55. Clear:. Processed in 0.058482 secs); 29 Mar 2004 21:51:36 -0000 Received: from unknown (HELO limacorp.com) (24.123.167.82) by garbanzo.limacorp.com with SMTP; 29 Mar 2004 21:51:36 -0000 Message-ID: <40689A62.5080507@limacorp.com> Date: Mon, 29 Mar 2004 16:51:30 -0500 From: Terry Hampton User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.0.1) Gecko/20021003 X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Quick System Catalog Query Question Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/375 X-Sequence-Number: 12944 All, select attname, atttypmod, atttypid from pg_attribute where attrelid=3701787 and attnum > 0; returns: attname | atttypmod | atttypid -------------+-----------+---------- acct_name | 132 | 1043 grp | 54 | 1043 name | 260 | 1043 id | 54 | 1043 proc_by | 54 | 1043 fldnames | -1 | 25 flddata | -1 | 25 I can't determine what SQL to which system catalog will associate "1043" to "varchar" and "25" to "text" many thanks for you help 7.3.2 on Linux Terry Terry L. Hampton Project Manager LimaCorp, LLC www.limacorp.com 513.587.1874