[ADMIN] Quick System Catalog Query Question

[Terry Hampton]

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


---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend