Quick System Catalog Query Question - Mailing list 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