Bruce Momjian wrote:
>
> > > We have a new atttypmod field that holds the length for the column as
> > > defined at table-creation time for char() and varchar(). Is that the
> > > number you want?
> > >
> > > --
> > > Bruce Momjian
> > > maillist@candle.pha.pa.us
> >
> >
> > for varchar() and also for the datatype text it would be
> > nice to know the actual length. If this is not possible,
> > then the length at creation time is still better than -1.
>
> If you use binary cursors, you can use VARSIZE and VARDATA to see the
> size and data for a string type.
>
> --
> Bruce Momjian
> maillist@candle.pha.pa.us
For the perl interface (DBD-Pg) I can not use cursors at all,
because they can not be nested.
Edmund
--
Edmund Mergl mailto:E.Mergl@bawue.de
Im Haldenhau 9 http://www.bawue.de/~mergl
70565 Stuttgart fon: +49 711 747503
Germany gsm: +49 171 2645325