Quick System Catalog Query Question

From: Terry Hampton <thampton(at)limacorp(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Quick System Catalog Query Question
Date: 2004-03-29 21:51:30
Message-ID: 40689A62.5080507@limacorp.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Jaime Casanova 2004-03-29 21:56:22 Re: Raw vs Filesystem
Previous Message Lamar Owen 2004-03-29 21:41:20 Re: postgresql.conf file and logging questions