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