Terry Hampton <[EMAIL PROTECTED]> writes:
> Manuel,
>
> Many thanks for your quick reply. When I
> enter: SELECT * FROM pg_type where typname='varchar';
>
>I get:
>
> typname | typowner | typlen | typprtlen | typbyval | typtype | typisdefined
> | typdelim | typrelid | typele
Terry Hampton <[EMAIL PROTECTED]> writes:
> I can't determine what SQL to which system catalog will associate
> "1043" to "varchar" and "25" to "text"
pg_type where oid = 1043, ie:
SELECT * FROM pg_type WHERE oid = 1043;
Regards,
Manuel.
---(end of broadcast)---
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 | 10
