MetaData (size of datatype)

Hi tom,

how to decode the atttypmod field........when i allocate 10 it shows it as 14
n for 20 it shows it as 24.......my problem is not just with
varchar........it is for all fields that has variable length .........the
same atttypmod returns -1 for integer? am confused........

I want the size allocated for each field i a table whether its a var-length
or fixed length........

Shra

On Saturday 27 April 2002 20:37, you wrote:
> Shra <shravan(at)yaskatech(dot)com> writes:
> > [ where to get declared-length info for var-length columns ]
>
> This is encoded in the atttypmod field (see PQfmod). I'd recommend
> using format_type() to decode the info, but if you don't mind possibly
> having to change your code from time to time, you could just wire
> knowledge of the interpretation of typmod into your code.
>
> In future, kindly be more selective about the lists you cross-post to.
> I generally make a practice of ignoring questions posted to the bugs
> list, for example.
>
> regards, tom lane

--
Shra