| 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: | Whole Thread | Raw Message | 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
| 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 |